Steve McFarland
asked on
Crystal Reports last day of month
I am using this to get the last day of the month
date(year({OPERATION.SCHED _START_DAT E}),month( {OPERATION .SCHED_STA RT_DATE})+ 1,1)-1
It works until the OPERATION.SCHED_START_DATE is in December. Then I get the following:
A month number must be between 1 and 12.
What do I need to change for it to recognize going from December to January?
date(year({OPERATION.SCHED
It works until the OPERATION.SCHED_START_DATE
A month number must be between 1 and 12.
What do I need to change for it to recognize going from December to January?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER