The time is passed as a string. which includes date and time. i need to make a filter where i can filter the data by time.
E.g. “1/3/2025 4:49:34 PM”.
Any idea?
Answer
how to add filtered by time in Generic Inquire
Best answer by rashmikamudalinayake10
I was able to find a solution. This is my approach,
Converted to 24-hour format and returned a Boolean value based on the difference.
+15You can get the hour, minute, and second portion of a date and time with these functions:
If you could be more specific with your use case, I may be able to suggest something more specific.
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Hi
This is for use in a generic inquiry, where a user can filter records by time. I thought of using a combo box option since there are AM/PM values, but I'm not clear on how the logic would work.
Any alternative suggestions and how the logic would be like?
+15Ah, I see. In that case, I’d add the CRCase table to the GI (without joining it) and add a parameter (or two) with the schema set to CRCase.ReportedDate (or it may be called Created Date). This is a field specifically designed to allow entering time. You should be able to compare other system dates to these parameters.
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
{{@m!t r@nj@n}}
I was able to find a solution. This is my approach,
Converted to 24-hour format and returned a Boolean value based on the difference.
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.