day function in ms access doesn't return the day name and there isn't a function date name

[rudolfelizabeth]

Day([[DrawDate]) should return the date name in a query criteria field instead it returns the date number how do you get the date name instead of the number, and can anyone inform why do you need the date number in real life situation, I don't understand the programmers at ms.
here's my code
Day([DrawDate])

 

[pjw001]

I assume you meant the "day name", not "date name".

Try the function "WeekdayName".

Needing to know the day of the month does not seem unreasonable.

 

[dhookom]

You can also use Format([DrawDate],"dddd")

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

Unless by 'date name' you mean something completely different.
Could you tell us what data you have and what you expect to get out of this 'date name'? A few examples would be nice to see...

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson