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