Help

DATETIME_DIFF if second date is blank

Topic Labels: Formulas
Solved
Jump to Solution
1102 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dani_Oliver
6 - Interface Innovator
6 - Interface Innovator

Hey everyone. I’m using this formula to calculate how many days it took for a response.

DATETIME_DIFF({Response date},({Submission date}), ‘days’) & " days"

I’d like to add a part to the logic that says if {Response date} is blank, calculate days between Submission date and today’s date.

Any ideas?

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

For formulas like this, I like to use a multi-line format

DATETIME_DIFF(
  IF({Response date}, {Response date}, TODAY()),
  {Submission date}, 
  'days'
) 
& " days"

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

For formulas like this, I like to use a multi-line format

DATETIME_DIFF(
  IF({Response date}, {Response date}, TODAY()),
  {Submission date}, 
  'days'
) 
& " days"