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