Help

Date String: Number of Days as numeric value

Topic Labels: Formulas
Solved
Jump to Solution
928 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Jarryd_Williams
5 - Automation Enthusiast
5 - Automation Enthusiast

I was wondering if someone was able to help me out.

I am looking use a formula to calculate the amount of days until an item has to be renewed. What I would like is that when it’s nested within an IF statement it is calculated as a VALUE rather than a STRING.

The reason for the IF statement is that when the Expiry Date is empty, no value will show in the “Days Remaining” Field.

Here is the formula:
IF({Passport (Expiry)}=BLANK(),’’, DATETIME_DIFF({Passport (Expiry)},TODAY(),‘days’))

I’m likely missing something really obvious in this regard.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Here’s one way to solve it:

IF(
{Passport (Expiry)}!="",
DATETIME_DIFF({Passport (Expiry)},TODAY(),'days')
)

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Here’s one way to solve it:

IF(
{Passport (Expiry)}!="",
DATETIME_DIFF({Passport (Expiry)},TODAY(),'days')
)
Jarryd_Williams
5 - Automation Enthusiast
5 - Automation Enthusiast

@ScottWorld This worked perfectly. Thanks so much.