S
Sue
I want to calculate time intervals between 2 dates - today and a
user-specified date in the past. I fiddled around & came up with the
following fomulae:
Int(Now()-[D1Tx]) -> the # of days between D1Tx and today
Int((Now()-[D1Tx])/7) -> the # of weeks between D1Tx and today
Int((Now()-[D1Tx])/365) -> the # of years between D1Tx and today
The problem is that these don't show any difference between (1 year + 1 day)
and (1 year + 364 days). How do I make these formulae - especially the last -
a bit more meaningful?
And what if I'd also like the user to be able to enter the past date of
interest and a date other than today, i.e. if they want to know what the
interval will be when there's an appointment in the future in which the
interval between the past date and the date of that future appointment?
Hope I'm not being TOO incoherent.
Thank you!
user-specified date in the past. I fiddled around & came up with the
following fomulae:
Int(Now()-[D1Tx]) -> the # of days between D1Tx and today
Int((Now()-[D1Tx])/7) -> the # of weeks between D1Tx and today
Int((Now()-[D1Tx])/365) -> the # of years between D1Tx and today
The problem is that these don't show any difference between (1 year + 1 day)
and (1 year + 364 days). How do I make these formulae - especially the last -
a bit more meaningful?
And what if I'd also like the user to be able to enter the past date of
interest and a date other than today, i.e. if they want to know what the
interval will be when there's an appointment in the future in which the
interval between the past date and the date of that future appointment?
Hope I'm not being TOO incoherent.
Thank you!