DiffDays function

DiffDays function

  
Please note in attached:
--  the values of fromDate and toDate, both DateTime types
--  the calc'd field in red, which is a result of the first Assignment

How does DiffDays(fromDate, toDate) yield 3437?

Phil

DiffDays returns the number of days between dates.

I checked in Excel and that's the right number.
Between 2004-09-05 and 2014-02-02, 3437 days have passed.
You can get more information on buildin functions in the expression editor:


I am so-o-o-o-o-o-o embarrassed. I was misreading the data.

Thanks for the reply and follow-up.

Phil