Hi all,
I need some assistance please
I need to calculate a series of dates and month and not sure on the way forward
Installation Date - 2022/02/01
Frequency - 24 Months
Todays Date - 2022/03/03
Consumed - 2 Months
Formula= Installed Date + Frequency - Today's Date - Consumed
Result to be in Months
I assume I need to use DateDiff in conjunction with DateAdd
I need some assistance please
I need to calculate a series of dates and month and not sure on the way forward
Installation Date - 2022/02/01
Frequency - 24 Months
Todays Date - 2022/03/03
Consumed - 2 Months
Formula= Installed Date + Frequency - Today's Date - Consumed
Result to be in Months
I assume I need to use DateDiff in conjunction with DateAdd
Last edited: