Hi All,
Question on date filtering. I have a list of dates in a field I applied the formula below to filter out the latest 3 months of date but its not working. Could someone help?
One item of note on the date field is that it will always end at last day of the prior month. Example in September I will get a data file from Jan 01 2018 till august 31 2019.
my formula:
[Completion Date] >= DateTimeAdd(DateTimeToday(), -3, "months")
sample data set below: I want it to capture latest 3 months.
| Completion Date |
| 5/22/2019 |
| 5/31/2019 |
| 6/3/2019 |
| 6/4/2019 |
| 6/5/2019 |
| 6/6/2019 |
| 6/29/2019 |
| 6/30/2019 |
| 7/14/2019 |
| 7/29/2019 |
| 7/30/2019 |
| 7/31/2019 |
| 8/1/2019 |
| 8/2/2019 |
| 8/3/2019 |
| 8/29/2019 |
| 8/30/2019 |
