date minus a certain amount of days

[ozzy78910]

Hi all

I want to subtract 20 days from a date value, how is this done using a formula icon?

thanks

osman

[fmvizcaino]

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

[MichaelLaRose]

Hi Ozzy,

The formula you are looking for is:

DateTimeAdd([Date],-20,"days")

Best,

Michael

[rupali_bhise · Accepted solution]

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