Calculating number of days between two date fields

[#1]

Hi ... I want to calculate the number of days between two date fields in MM/DD/YYYY format.

What would be the best way ?

Thanks

[marcus_sommer]

(Real) dates are just numbers - therefore you could calculate: Date2 - Date1. If they are not dates than you need to convert them with date#() and maybe with floor() to cut a time-part.

- Marcus

[eromiyasimon · Accepted solution]

=date(Field_name,'MM/DD/YYYY')- date(Field_name,'MM/DD/YYYY')