Expand my Community achievements bar.

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.