Hello,
I'm trying to filter for everything within the next 2 months but all I'm getting is data for December.
Can anyone see what I'm doing wrong?
DateTimeAdd(DateTimeFirstOfMonth(),+2,"months")= DateTimeTrim([DateTime_Out],"months")
Thanks,
Phill
Solved! Go to Solution.
Thanks @atcodedog05 defiantly getting closer. Though its taking everything from the start of October rather from the date of running it. I tried to modify it to use DateTimeNow() but that cut out dates in October for some reason.
Hi @Phill
Here are the modified formulas
2 months from today
(DateTimeAdd(DateTimeNow(),+2,"months") >= DateTimeTrim([DateTime_Out],"months"))
and ([DateTime_Out]>=DateTimeNow())
Output:
Hope this helps 🙂
Hi @Phill
Additionally you can use DateTimeToday() instead of DateTimeNow() to include today also.
(DateTimeAdd(DateTimeNow(),+2,"months") >= [DateTime_Out])
and ([DateTime_Out]>= DateTimeToday())
Output:
Hope this helps : )
Thanks @atcodedog05 that's perfect! Just what I needed. I think I can see where I went wrong too.
Happy to help 🙂
Cheers and happy analyzing 😀