Today is ..

  • Thread starter Thread starter Uncle Sam
  • Start date Start date
U

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
 
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)!
Click to expand...

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