Date time difference and output as Date

[AJ-CH]

Hello, 

I am trying to use a date-time difference formula to get the date as output. Need to subtract 365 days from the Max_Dateofservice field and the out should be a date. 

DateTimeDiff([Max_Dateofservice],'-365', u), what I should replace u with  to get the date. If [Max_Dateofservice] is 01/01/2020 then after this function I will need output as 01/02/2019

Please suggest.

[MarqueeCrew · Accepted solution]

If I wanted to subtract 365 days from a date, I'd use:

DateTimeAdd([Max_Dateofservice],-365,"days")

 cheers,

Mark 

[AJ-CH]

@MarqueeCrew, 

thanks for your response. I thought if I will use days then it will give me output as the difference between the days but I got the actual date... Thanks a lot 

[MarqueeCrew]

@AJ-CH ,

 no worries. With alteryx you can trial and error your way through most challenges. I use it often. 

cheers,

 mark