Skip to Content
0
Former Member
Oct 31, 2012 at 06:49 PM

Crystal Reports; SQL expression for end of month

201 Views

Hey ya'll. I have been using a formula for end month, which irconically does not work on the last day of the month. The following formula relates to the 'fiscal date' of a summary table that is used by my company and is relevant to all reports that are developed.

add_months(curdate(), 1)-dayofmonth(curdate())

Does anyone see the flaw in this formula? It is designed to give the last day of month, but I have noticed a problem with these reports that are scheduled the last day of the month.


Thank you! Any help you can provide is very much appreciated!!!

Marlene

Crystal Reports 2008

Windows 7