Crystal Reports last day of month

I am using this to get the last day of the month
date(year({OPERATION.SCHED_START_DATE}),month({OPERATION.SCHED_START_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?
slmcAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Try this

DateAdd('m',1,Date(year({OPERATION.SCHED_START_DATE}),month({OPERATION.SCHED_START_DATE}),1)) -1

Open in new window


mlmcc
0
 
slmcAuthor Commented:
That is it.  Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.