Trying to pull data from Aug 1 - Aug 31 but my solution is leaving out Aug 1 entries

Question

even though the data preview shows 2023-08-01 as first day of previous month data, the output does not include data with that data, my output only includes data from all other days in Aug except Aug 1st ... can someone tell me what I am doing incorrectly?  thank you

SPetrie · Answer

This is just a guess without seeing the data, but what is the data type of your Manager Notification Date column?

Is it set to date instead of date/time?

If its date, then you are comparing 2023-08-01 to 2023-08-01 00:00:00.

The date with time will be greater than the date without time so it will fail the first condition of your filter, which is why it would get left out.

DataNath · Answer

Hey @bh1789, you'll need to wrap your fields in the ToDate() function (or output them from your Formula expressions as just a Date data type). So it'd be:

ToDate([First Day Previous Month]) <= [Manager Notification Date] AND [Manager Notification Date] <= ToDate([Last Day Previous Month])