Controls

Re: How to calculate a leap year

Clay Fox — Fri, 18 Apr 2008 14:11:35 GMT

Still not sure what you want.

so you want to add 5 years to 4/18/2008 and get 4/18/2013? Even though that is not 365x5 days?

If it is that simple you can use substrings and concatenate to create your date. Seperate the year, add the amount, and then concatenate it back together again.

Re: How to calculate a leap year

edwardvn — Fri, 18 Apr 2008 12:30:07 GMT

Thank you very much for your very quick response, I am trying but still cant do it.

All i m trying to do is take a years value, say 5 and add exactly 2 years to it and return the new date taking into account leap years etc.

I have been at it for hours and just cant work it out. Would you be able to help me?

Kind Regards

Edward

Re: How to calculate a leap year

edwardvn — Thu, 17 Apr 2008 16:38:39 GMT

Thank you very much for your very quick response, I am trying but still cant do it.

All i m trying to do is take a year, say 5 and add exactly 2 years to it and return the new date taking into account leap years etc.

I have been at it for hours and just ant wok it out.

Kind Regards

Edward

Re: How to calculate a leap year

Clay Fox — Thu, 17 Apr 2008 16:21:27 GMT

Welcome to the forum Edward.

You need to use the DateDiff vbscript.

Search on DateDiff here and you can find some samples.

How to calculate a leap year

edwardvn — Thu, 17 Apr 2008 14:47:53 GMT

I am trying to add 5 years onto a simple date that is picked by the user, but using the adddays *365 doesnt take into account leap years.

Pleae could someone be kind enough to tell me what the calculation is

Thank you very much in advance.

Edward