Days Between Formula

[AssetHound]

I'd like to create an IF statement that checks for the number of days between the starting and ending report dates, and calculate an expression based on whether or not the report period length is over/under a fixed number of days. The usage of EVAL and other days functions aren't clear to me, however. Thanks for any help.

[Mark]

Hi AssetHound,

You can use something like:

IF((ENDDAYS()-STARTDAYS()) > 30, 1, 0)

so, if the date range of the report is more than 30 days, it will return 1, and if not, it will return 0. You can replace 1 and 0 with your desired expressions, and you can of course change 30 to whatever you wan.