Filter a date

Question

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!

HomesickSurfer · Answer

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

Maskell_Rascal · Answer

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