calculating next month 1

[Sumisu]

hi,

i have to calculate the date of the next month in crystal:

eg: 15-FEB-2003 should be 15-MAR-2003

I can do it like {Date} + 30 but then it would not be the 15th for each month because the length of each month is different...

any ideas?

thanks a lot!

 

[lbass]

Try the dateadd function:

dateadd("m",1,{table.date})

-LB

 

[Sumisu]

great - that works fine - did not know that funtion...

Thx a lot!

Elmar

 

[kenhamady]

This works in version 8 and above. For version 7 or lower I have formula for adding months on the formulas page of my web site.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com