Printing a Report on a Specific Day

[Guest]

I have a macro that will allow users to print specific reports by clicking on
a button. On one day of the week I need a somewhat different report to
print, but I don't want to add another button to the form. I would like the
macro to print the correct report by determining the day of the week from the
system clock. I have tried several differnt filtes, but can't seem to get
the correct syntax. Can someone point me in the right direction?

 

[Nikos Yannacopoulos]

Kellogg,

You've probably already discovered how to use conditions in a macro...
if not, while in Macro design, run menu item View > Conditions. This
allows you to execute the action next to a condition only if the
condition is met.
Now, the way to determine the current day of week, is through the use of
function Weekday. So, if you want a different report on, say, Monday,
then you would do something like:

Condition Action
WeekDay(Date,0) = 1 OpenReport (report A)
WeekDay(Date,0) <> 1 OpenReport (report B)

HTH,
Nikos

 

[Guest]

I tried adding the condition, but when I save the macro it puts brackets
around the word date and gives me the error message "can't find the name
'Date' you entered in the expression".

 

[Steve Schapel]

Kellogg,

Try it like this...
WeekDay(Date())=1

 

[Guest]

This works just the way I had envisioned.

Thanks!!!