I’m trying to obtain the difference between 2 dates (going out 2 decimal places). I did format the result as a decimal going out 2 places. However, I am only getting whole number results.
My columns are:
Lease End - set up as a date
Today’s Date - set up as a formula: Today()
Lease Remaining - set up as a formula: DATETIME_DIFF({Lease End},{Today’s Date}, ‘Years’)
Any help appreciated!
Hi @Alex_Everest - the DATETIME_DIFF formulas only give results in whole numbers (of whatever unit you’ve chosen), so even when you select a format of decimal with 2dp, you get “.00” at the end. You could try this:
Use a smaller unit, then divide by the number of that unit in a year. So for example “weeks” is:
DATETIME_DIFF({Lease Date}, TODAY(), 'weeks')/52
Hi @Alex_Everest - the DATETIME_DIFF formulas only give results in whole numbers (of whatever unit you’ve chosen), so even when you select a format of decimal with 2dp, you get “.00” at the end. You could try this:
Use a smaller unit, then divide by the number of that unit in a year. So for example “weeks” is:
DATETIME_DIFF({Lease Date}, TODAY(), 'weeks')/52
Worked perfectly, thanks @JonathanBowen
Appreciate it!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.