Alteryx help with date range selection-by system date

[jeetamar11]

Hi, 

I am using this formula to choose all the days in the month Month to date.

DateTimeMonth([Case Created Date]) = DateTimeMonth(DateTimeNow()) AND DateTimeYear([Case Created Date]) = DateTimeYear(DateTimeNow())

But today(May 1st) when we are in new month but I still need to report data as per full April month. The querry is giving me no result as system date is new month. Can someone help me sp When we are on the forst of new month -it givers me data for whole last month.?

thank you in advance!

[rzdodson · Accepted solution]

Cross-threading from this duplicate thread:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Date-range-selection-by-the-sy...

Try the attached, @jeetamar11 

[jeetamar11 · Accepted solution]

This worked: DateTimeMonth([Case Created Date]) = DateTimeMonth(DateTimeNow())-1 AND DateTimeYear([Case Created Date]) = DateTimeYear(DateTimeNow())

Thank you!