Macro condition on day of the week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 26 Nov 2003 08:10 GMT

I am looking for the syntax for the condition for a macro
which would conditional on the day of the week.

I am using [Forms]![PerformanceStatus]![DAY]="Monday" but
this doesn't work.

The [DAY] field is a date/time field with the format set
to "dddd" but this doesn't work.

Any assistance would be greatly appreciated.

Rob

Reply to this Message

losmac - 30 Nov 2003 14:35 GMT

Use WeekDay function, which returns value from 1 to 7
vbSunday    1
vbMonday    2
vbTuesday    3
vbWednesday    4
vbThursday    5
vbFriday    6
vbSaturday    7

WeekDay([Forms]![PerformanceStatus]![DAY])=2

>-----Original Message-----
>I am looking for the syntax for the condition for a macro
[quoted text clipped - 10 lines]
>Rob
>.

Reply to this Message