Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 13, 2022 08:40 AM
Hello,
I want to calculate the number of days of a mission,
either from a period of time with beginning and end dates - which I can do with the [ DATETIME_DIFF() function]
or (and this is where I have an issue), from a list of specific dates. I want to make the sum of theses days. What is the formula for that please?
Apr 19, 2022 06:08 AM
Hi @Elodie_Delneuf and welcome to the community!
I’m assuming that this is a selection field and thus outputs a text, rather than a date. If that is the case, you could try using DATETIME_PARSE() in combination with a DATETIME_DIFF().
DATETIME_DIFF()