Today is ..

[Uncle Sam]

Dear Group

There are times in life when you ask silly questions, one
that you should know the answer and this is one of them.
Which date functions do you use to calculate the day of
the week, e.g. Monday for today’s date?

It escapes me and I have done it a million times (at
least)!

Uncle Sam

 

[Terry Kreft]

look at Format and DatePart

 

[John Vinson]

Dear Group

There are times in life when you ask silly questions, one
that you should know the answer and this is one of them.
Which date functions do you use to calculate the day of
the week, e.g. Monday for today’s date?

It escapes me and I have done it a million times (at
least)!

DatePart("w", <date value>

returns 1 through 7 for the days of the week;

Format(<date value>, "dddd")

returns the name of the day of the week as a string.

 

[Peter De Baets]

MsgBox Format(Date, "dddd")

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com