Date column

[reshma11]

How to add 2 years to system current date.

Thanks.

[chulett]

Depends on how picky you are about "two years". If you go with the definition that says a year is 365 days, then use DateFromDaysSince() to add 730 days to the system date.

[Sainath.Srinivasan]

What does 2 year constitue ? What is 2 years from 29/02/2008 ?

365 days per year or 12 months per year or only 2 years increment.

For first, you can do a DaysFromDateSince().

For other 2 options, search for DateToString() and StringToDate().

[reshma11]

[quote="reshma11"]How to add 2 years to system current date.

Thanks.

only 2 years increment and the format should be YYMM

[Sainath.Srinivasan]

I will suggest you try from the given information rather than asking the full solution.

We expect some effort from you also - apart from typing your requirement.

[chulett]

Hmmm... then that sounds like just a little substring work and adding 2 to the YY portion before you glue them together.

[ray.wurlod]

With a little care where YY is "98" or "99".

[chulett]

Ah, true... you'd need to constrain it to the rightmost two digits but that's simple enough.