Skip to main content
Question

"Is between" on client side and server side

W
Jr Varsity III
Forum|alt.badge.img

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.

Why?

 

Thanks,
Woody 

    0 replies

    Be the first to reply!

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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