How do you get the day name not the date value in ms access 2010 1

[Panchovia]

Day: Day(Format([drawdate],"dd/mm/yyyy"))

This code should give you the drawdate name instead of the value or not if not how do you get the day name I've tried various options in ms 2010 none gives you the name of the day.

 

[dhookom]

Try:

Day: Format([drawdate],"dddd")

Duane
Hook'D on Access
MS Access MVP

 

[Panchovia]

Correct,

Thank you very Much

 

[SkipVought]

These are not mutually exclusive
[tt]
DayDate: Format([drawdate],"dddd mmmm dd yyyy")
[/tt]
for instance. E pluribus unum.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]