Filter tool formula meaning

[The_Voter]

Dear all i'm trying to figure out few wf from my previous colleagues and i have troubles understanding why filter tool doesn't work.

[DateTime_Out] = DateTimeFormat(DateTimeAdd(DateTimeToday(),-18,"days"),"%Y-%m-%d")

could you please explain meaning of this filter?

[atcodedog05 · Accepted solution]

Hi @The_Voter 

Below filter means filter [DateTime_Out] where it is 18 days back from today.

DateTimeFormat( // Format as YYYY-MM-DD (this done to remove time part)

DateTimeAdd( // add -18 days which is 18 days previous to current date

DateTimeToday() // today date

,-18,"days")

,"%Y-%m-%d")

Hope this helps : )

[atcodedog05]

Happy to help : ) @The_Voter 

Cheers and have a nice day!