Aug 19, 2019 07:48 AM
Hello,
I’m trying to make a formula that counts the difference between start date and end date, however if end date is blank calculate the difference between start date, and current date.
Sorry if it sounds simple, i’m very new to airtable!
Thanks
Matt
Solved! Go to Solution.
Aug 19, 2019 08:29 AM
Hi @Matthew_Grundy - try this:
IF(
{End Date},
DATETIME_DIFF({End Date}, {Start Date}, 'days'),
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)
JB
Aug 19, 2019 08:29 AM
Hi @Matthew_Grundy - try this:
IF(
{End Date},
DATETIME_DIFF({End Date}, {Start Date}, 'days'),
DATETIME_DIFF(TODAY(), {Start Date}, 'days')
)
JB
Aug 19, 2019 06:17 PM
Here’s another way to write it, putting the IF function inside a single DATETIME_DIFF:
DATETIME_DIFF(IF({End Date}, {End Date}, TODAY()), {Start Date}, "days")
Aug 20, 2019 01:48 AM
Works perfectly!
thank you for your help.
Matt