How to calculate a Date plus or minus a certain nu...

[micha281sth]

Hello, 

I am looking for a way to calculate a date minus x days based on a date field. I.e. the result should be 31.12.2023 (DD.MM.YYYY) minus 10 days = 21.12.2023. 

How can I do this? 

I tried to use this formula, but it returned an error: 

DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')

Thanks for help, 
M.

[micha281sth · Accepted solution]

Sorry, had a typo in the formula. It does work 🙂 

So this is working: 

DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')

[Spruce]

Hi @micha281sth , I'm trying to do this too, but with a couple tweaks. I'd like to show a date field that is 3 workdays later (+3 workdays) from the reference date field. 

I get an error when trying to do +3, and if I just use "3", it either adds zero or just one day... I'm confused!

This is my formula: 

DATETIME_FORMAT(DATEADD(Created, 3, 'workdays'), 'MM/DD/YY')

Thanks in advance!
Devon