I have a GI that outputs SOOrder information.
In the GI settings I use two date fields to do SO Created Date is between two dates. If I enter 9/11 and 9/15, sales orders created from 9/11 through 9/14 are returned, when I would expect SO's from 9/11 to 9/15 to be returned.
If I do the same filtering using the column header in the report, I enter 9/11 and 9/15, sales orders created from 9/11 through 9/15 are returned, as expected.
I believe the 'between' in the GI is broken.
Best answer by vincea11
+11Hi
The reason is that the CreatedDateTime field in GI shows Hour:Minute:Second as 00:00:00
In your example: Between: 9/11/2025 to 9/15/2025 => Understand as 9/11/2025 00:00:00 to 9/15/2025 00:00:00 so dates like: 9/15/2025 10:20:30 ; 9/15/2025 09:50:10 is not in this time period.
I also don't know why the CreatedDateTime field in Acumatica’GI is designed to display like that?
Best Regards,
NNT
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
