Filter a date

[angelique_martin]

Hi Alteryx community,

I am currently trying to determine how I can create a filter for a date column that reads greater than or equal to todays date. I tried to do a basic filter screenshotted below but I am still having trouble on how to write the "Today's date" part. Any help will be greatly appreciated. 

Thanks!

[Maskell_Rascal]

Hi @angelique_martin 

You can use the Custom filter option to do this with the following formula. 

[Agr_Valid_To]>=DateTimeToday()

This will always filter to a date greater than or equal to the date the workflow is ran. 

Hope this helps.

Cheers!

Phil

[HomesickSurfer]

Hi @angelique_martin 

Further to the solution offered by @Maskell_Rascal , you can use the following that targets the start of the workflow run (in case it starts before midnight and evaluates the formula after midnight):

[Agr_Valid_To]>=DateTimeStart()