Hi all
I want to subtract 20 days from a date value, how is this done using a formula icon?
thanks
osman
Solved! Go to Solution.
Hi @ozzy78910 ,
That is achievable with the help of datetimeadd function.
DateTimeAdd([Date],-20,'days')
https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm
Best,
Fernando Vizcaino
Hi Ozzy,
The formula you are looking for is:
DateTimeAdd([Date],-20,"days")
Best,
Michael
Hey @ozzy78910 ,
You can use below mentioned formula for subtract to date time in days.
DateTimeAdd([Date],-20,'days')
DateTimeAdd (<date/time>, <interval>, <units>)
The <date/time> - datetime you want to manipulate,
The <interval> specified the amount of time to be added, and
The <units> the date/time units to add. The units are years, months, days, hours, minutes, or seconds (only one can be used), and the interval can be either positive or negative.
Good luck