Hello Samantha,
There's two functions that can do this - DateDiff() and DateSubtract().
DateDiff() returns a Numeric value and can calculate the date difference in years, months, weeks or days:
Example: DateDiff(Now(), $ThisIsYourDateField, 'd')
DateSubtract() returns a Duration value and can calculate the date difference in working days or non-working days:
Example: DateSubtract(Now(), $ThisIsYourDateField, TRUE)
I hope this helps,
Roland
Comment actions