Skip to main content
Solved

DATETIME_DIFF if second date is blank

  • Oct 4, 2020 5:16 PM UTC
  • 1 reply
  • 59 views

Dani_Oliver

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?

Best answer by kuovonne

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

DATETIME_DIFF(
  IF({Response date}, {Response date}, TODAY()),
  {Submission date}, 
  'days'
) 
& " days"
View original
This topic has been closed for replies.

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • Oct 4, 2020 9:08 PM UTC

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

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