What is the day today - Get using VBA??

[CharlesWhiteman]

Does anyone know how to find out what day of the week it is using VBA?

Thanks

 

[gemma-the-husky]

weekday(date) returns a number in the range 1 to 7

constants for these days are

vbsunday, vbmonday etc

does that help?

 

[CharlesWhiteman]

Hi, I am not sure if that helps.

Basically I am developing a query which (based on an if) will only run on a specific day of the week.

So, I need to identify in a query what day it is "today"

 

[DCrake]

Today:Format(Date(),"dddd") = Saturday

 

[CharlesWhiteman]

That did it! Thanks