This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to make this formula for the difference between 2 columns of date data. My starting formula was ({Date 2}) - ({Date 1}) and I only came back with NaN and 0.
So, I changed my formula to DATETIME_DIFF({Date 1},{Date 2}, ‘days’)
and
DATETIME...
Excuse me, the [ was a typo and should have been a { …
The columns in which the dates are located output dates, the field is date.
I actually just solved the problem. My final formula is
DATETIME_DIFF({Date of newer date}, {Date of older date...
