Date filters

[Phill]

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

[Phill]

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. 

[atcodedog05]

Hi @Phill ,

Its due to your DateTimeTrim("Month"). I will modify to consider date from today date.

[atcodedog05]

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 🙂

[atcodedog05 · Accepted solution]

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 : )

[Phill]

Thanks @atcodedog05 that's perfect! Just what I needed. I think I can see where I went wrong too. 

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀