Returning the DayOfWeek number

[Flupke]

When returning the DayOfWeek number, sunday gets 1 and saturday gets 7.
Is it possible to manupulate the DayOfWeek-function, so that monday gets 1 and sunday gets 7?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel

 

[bjd4jc]

Yes,

WeekDay(Date, vbMonday)

 

[cLFlaVA]

Why not

[tt]Weekday(Now, vbMonday)[/tt]

*cLFlaVA
----------------------------
A pirate walks into a bar with a huge ship's steering wheel down his pants.
The bartender asks, "Are you aware that you have a steering wheel down your pants?"
The pirate replies, "Arrrrr! It's driving me nuts!

 

[JSpicolli]

WeekDay(Now, 2)

 

[DrJavaJoe]

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.