Filter Date until Current Month

[JDong]

Hi All,

I am trying to show all records until current month, where the result will show data from beginning until current system month. So all future dated records will be filtered. I have a datetime field in my data.

Ex :

31/12/2025 00:00
31/12/2029 00:00
31/05/2020 00:00
02/04/2047 00:00
31/12/2017 00:00

So the result will show the rows with dates

02/04/2020 00:00
31/12/2017 00:00

Which are valid and rest will be filtered

How can I achieve the same in Alteryx ?

Thanks

[patrick_digan]

@JDong How about something like this:

[Your Date Field] <= DateTimeToday()

That will result in anything before today.

[JDong]

Thanks.

This says Error: Formula (352): The formula "Orderdate" resulted in a number but the field is a Date/Time. (Expression #4)

[patrick_digan]

@JDong You'll need to put the formula into a filter tool.

[JDong]

Thanks. What if I have NULLs or Blanks in the field and want them to be picked along with this condition ?

[patrick_digan · Accepted solution]

@JDong You can use an OR statement, something like: 

isempty([Your Date Field]) OR
[Your Date Field] = "" OR
[Your Date Field] <= DateTimeToday()

[JDong]

Perfect ! Thanks