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?
Solved! Go to 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 : )
Happy to help : ) @The_Voter
Cheers and have a nice day!