In a saved search, I noticed that the BETWEEN function (for dates) includes the later date but not the first date. Is this the standard behavior?
For example, if the formula is like CASE WHEN {date} BETWEEN 02/03/2025 AND 02/10/2025 THEN 1 ELSE 0 END
Results: Anything from 02/04/2025 to 02/10/2025 is captured. Not 02/03/2025