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 |
Solved! Go to Solution.
Hey, I've been trying to modify the suggestions here to get a filter that will just filter for the next 2 months from the date its run but I cant seem to get it right. Can anyone help?
Hi, I have a filtering question as well but it's for weekly data. My dataset has multiple weeks of data but I only need it to show the most recent 13 weeks (with the most recent week being week # 1) I used the following formula but it's just showing "0" and "-1". Sample workflow is attached.
ToNumber(DateTimeFormat([Date],"%U"))
>=
ToNumber(DateTimeFormat(DateTimeNow(),"%U"))-13
Thanks for your help!