Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: How to calculate a Date plus/minus X days

Solved
Jump to Solution
1858 0
cancel
Showing results for 
Search instead for 
Did you mean: 
micha281sth
6 - Interface Innovator
6 - Interface Innovator

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.

1 Solution

Accepted Solutions
micha281sth
6 - Interface Innovator
6 - Interface Innovator

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

So this is working: 

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

See Solution in Thread

2 Replies 2
micha281sth
6 - Interface Innovator
6 - Interface Innovator

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
6 - Interface Innovator
6 - Interface Innovator

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

Devon