Good Day,
I am currently creating a report that is a Year to Date report of incidents from our incident management system. The report will look at incidents on a month to month basis and then report back the total number of incidents per month on a year to date basis.
I am trying to put the start and end date of the report in the Report Header, but I am running into some difficulty.
The title I am trying to put in has the formula:
When I run the report, the title shows as January 1.00, 2,008.00 to January 15.00, 2009.00
The formula for the @StartofYear is:
//
Shared StringVar RunYear:= "";
//
If Month(currentdate) = 1 Then
RunYear := ToText( Year( currentdate()) - 1 )
Else
RunYear := ToText ( Year(currentdate()) );
//
MonthName (Month (DateTime (2007, 01,01))) + " " + ToText (Day (DateTime (2007, 01,01))) + ", " + RunYear
The formula for the @RunDay is:
MonthName (Month (CurrentDate)) + " " + ToText (Day (CurrentDate)) + ", " + ToText (Year (CurrentDate))
What I would like it to read would be:
January 1, 2009 to January 15, 2009.
And, if I ran the report on say, March 1st, I would want the title to read:
January 1, 2009 to March 1, 2009
What am I doing wrong?
Thanks!!!