Paramater - month as MM, year as YYYY
Hi, I have quite a few reports working well thanks to this great package, hoever I have just been given a few more reports to add on and cannot figure out how to get the parameters set :oops: I am looking for month and year, for the current month and year:- month in format of 01, 02, 03, ....12 year in format of 2007, 2008 etc So for today (04/09/2008) I would get the follow:- month:- 09 year:- 2008 Any ideas? I am sure it is easy but I just cannot get it working.......
Hi, I have quite a few reports working well thanks to this great package, hoever I have just been given a few more reports to add on and cannot figure out how to get the parameters set :oops: I am looking for month and year, for the current month and year:- month in format of 01, 02, 03, ....12 year in format of 2007, 2008 etc So for today (04/09/2008) I would get the follow:- month:- 09 year:- 2008 Any ideas? I am sure it is easy but I just cannot get it working.......