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 You can use an OR statement, something like: 

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