Skip to main content

Hello,

we would like to find a formula to count down 24 hours and end at 0 or if possible marked "canceled".

if anyone can help us i will be really grateful

thanks in advance

Try this:

IF(
ABS(
DATETIME_DIFF(
NOW(),
{Target Date},
'hours'
)
) != 24,
ABS(
DATETIME_DIFF(
NOW(),
{Target Date},
'hours'
)
),
"Cancelled"
)

 

Reply


Terms & Conditions