first day of month - require [y] parameter January?? I have 3 reports setup to run on the last day of the month at 11:55pm, so they show the months data.......however I have just found out that the reports are being sent everyday!!
They are setup to run on “Specific day of the month” value “Last Day”
-----------------
As a result I am going to set them up to run on the “First Day” of the month, my problem being the parameters I want to send:-
1st Report:-
Parameter Name:-Year Start:-
Parameter Name:-Month Start:-
2nd Report:-
Parameter Name:-Year Start:-
Parameter Name:-Month Start:-
3rd Report:-
Parameter Name:-Year Start:-
I do not know how I can get the to work, as in January I will actually be wanting to send it as the year before (thus I was doing it on the last day of the month)
For months I can do , but at a loss what to do for year????
Also, am I right to presume in January will equal 12?
jomuir- 10-10-2008
Been trying to resolve this for a few days now, and search the forum.....however I think I have just found my solution on the forum :oops: :oops:
I believe this will provide me with the year, minus a day:-
I think :)
Forumer™ is Voted #1 Free Forum Hosting provider
Build your own community today with the largest message board hosting company.