extracting day from date

  • Thread starter Thread starter tim johnson
  • Start date Start date
T

tim johnson

If today (2/24/2004) is Tuesday how can I extract
Tuesday form the date.

I tried DatePart("d", Date()) and get 24 but I want
Tuesday instead of 24. Nothing else I try seem to work

Thanks
 
Here are some alternatives. Today,

Weekday(Date())

will return 3,

DatePart("w", Date())

will also return 3, and,

Format(Date(), "dddd")

will return "Tuesday".

There are also other alternatives involving the Format function (using
"ddd", "w", and "aaaa" formats). See the help for details.
 
Back
Top