Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 01, 2023 05:47 AM
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.
Solved! Go to Solution.
Jun 01, 2023 05:48 AM - edited Jun 01, 2023 06:28 AM
Sorry, had a typo in the formula. It does work 🙂
So this is working:
DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')
Jun 01, 2023 05:48 AM - edited Jun 01, 2023 06:28 AM
Sorry, had a typo in the formula. It does work 🙂
So this is working:
DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY')
Oct 10, 2023 09:19 PM
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