extracting day from date

[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

 

[Brian Camire]

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.

 

[Cheryl Fischer]

Try this ...

Format(Date(),"dddd")

hth,