Macro condition on day of the week

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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
 
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
 
Back
Top