Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculating months instead of days

Avatar

Level 3

Dammit!  My client wasn't happy with me calculating 90 days from a given date field.

He wants 3 months.

So I thought I'd solved my problem, but I haven't.  Can anyone help me to calculate 3 months instead of 90 days.

eg. If the 'from' date is 23/05/11, he wants the 'to' date to result in 23/08/11.  Which of course will not necessarily be 90 days.

Thanks,

Peta

3 Replies

Avatar

Level 9

Hi Peta,

Here is a link what you are after. But it's not complete. You need some more validations. But It can act as an eye-opener.

Thanks,

Bibhu.

Avatar

Level 3

Hey Bibhu,

Thanks for coming back to me on this, but where is the link?

Peta

Avatar

Level 9

Oops !!1 Sorry Peta. Here is the link https://acrobat.com/#d=gxvf6sFTf5T1W7Yr6KpotA. But it's not full proof. It will just give you a rough idea.

Thanks,

Bibhu.