Calculating Last Months, Month End Date, - Tricky 1

[jonwolds]

Hi, i'm struggling to calculate last months month end date.

i.e 30/09/2002

This date needs to change each month so a calculation is needed.

Thanks

Jon

 

[kenhamady]

If you want the end of the prior month based on the your computer system date use:

CurrentDate - Day ( CurrentDate )

If you want it based on a specific date field or a prompted date, replace both instances of currentdate with that date field or prompt. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com