Search for a Specific day (Monday)

[marrett]

Hi

Is there a way to search for a day of the week. I don't care what the date is I just want to check to see if it is a Saturday or sunday.



Thanks,

Maria

 

[Fuga]

Yes, you use weekday([yourfield]). This returns an integer representing the day of week. However I don´t remember which is for saturday.

Fuga.

 

[Rich]

You could also use
If Me.MyDate =vbSaturday Or vbSunday Then
DoSomething

 

[marrett]

Weekday

Thank,

I kew it would be simple. I just could find it.

Thanks for your time,

Maria