I'm using the following filter, but it's not including any transactions from the last day of the month. I think this filter assumes 12:01am. I need to include through 11:59:59PM.
[TRL_DATE]<=_last_of_month(?ReportDate?)
Asked
Active
Viewed 298 times
-1
-
If either of those are timestamps, cast them as dates. – Andrew Feb 10 '22 at 18:46
-
What database are you using? This link may help: https://stackoverflow.com/questions/16646585/sql-query-to-find-the-last-day-of-the-month – VAI Jason Feb 24 '22 at 14:47
