Setting month and year parameters automatically 2

[cousnvinnie]

Hi all!

Newbie here...

I am trying to get a report that will only retrieve data for the current month and year without having to input the parameters in manually. Any help in getting this to work is graetly appreciated.

Thanks

 

[TheBlondOne]

Depending on how your database field is which holds the date you could use the following code in your select expert.

month({Field}) = month(currentdate) and
year({Field}) = year(currentdate)

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[GJParker]

To retrieve data for the current month go to Report menu -> Selection Formulas -> Record and enter the following formula :- (replacing {MyTable.Date} with your own field)

{MyTable.Date} in MonthToDate

HTH

Gary Parker
MIS Data Analyst
Manchester, England