"Is between" on client side and server side

Userlevel 2

Hi There, 

Just checking if there is better answer for this.

I know that when using “is between” in SQL Server, or GI,  start date is inclusive and end date is exclusive since time default to 12:00AM. 

But on Case screen, if I do a filter using “is between” on date column,  the end data record is included unless I manually change the time to 12:01AM.




0 replies

Be the first to reply!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved