Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=date(Field_name,'MM/DD/YYYY')- date(Field_name,'MM/DD/YYYY')
(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
=date(Field_name,'MM/DD/YYYY')- date(Field_name,'MM/DD/YYYY')