Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting month and year parameters automatically 2

Status
Not open for further replies.

cousnvinnie

IS-IT--Management
Aug 30, 2005
1
US
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
 
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"!!! :eek:)
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top