Aug 26 2019 08:22 AM - edited Aug 26 2019 08:24 AM
Aug 30 2019 08:18 AM
Hello hrandall,
I think you need to use DateDiff() for this. This is the formula I used to calculate the difference between 2 dates, returning a "0" if one date was less than another:
=IIf(DateDiff("d",[StartDate],[EndDate])<=0,"0",DateDiff("d",[StartDate],[EndDate]))
Use this formula in the Control Source of your Form or Report to calculate the difference between the dates, returning a "0" if the End Date is less than or equal to the Start Date.
Hope this helps.
Jan 15 2020 07:40 AM