How to calculate a Date plus/minus X days

[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')