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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Variable Dates in Macro

Status
Not open for further replies.

taketime

IS-IT--Management
Jan 23, 2004
5
US
Hi all - I have a report I'm attempting to run via macro and having difficulty setting date format/parameters. Here is syntax that compiles ok, but not running correct.

I need variable 1 to be 1st of the month and variable 2 to be the last day of the month.

LoadReport "*report filename*" , "@repvar1=(month(date$)01(year(date$) , @repvar2=(month(date$)31(year(date$))"

Also - any advice on 'scheduling' reports to run unattended?







 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top