Duration Calculation Problem

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a formula If (IsNull([Received On]),Today()-ToDate([Date Created])) that works fine but I want to change "Date Created" to "Date Sent" but I receive an error. The only thing I can figure out that is different is date created is a Date/Time field and Date Sent is only a date field. How can I fix this? 

Photo of Brian Burkett

Brian Burkett

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 5,224 Points 5k badge 2x thumb
Anytime you have a Date/Time field to compare with a Date field, you need to use ToDate([Date/Time Field]).

In your case, you are trying to use ToDate([Date Field]) which is throwing the error.  So, remove the ToDate() component around your date field, and it should work fine.