Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return Weekday Name

Status
Not open for further replies.

Zonie32

Technical User
Jan 13, 2004
242
US
I need to return the weekday name, ie Monday, Tuesday, etc in my query based on a date field. I can't figure out the format. Can someone help?

I have Format:([DateField],"ww") but that gives me numbers, I need the weekday name. Thanks.
 
You can use:

Format:([DateField],"ddd")

Or

Format:([DateField],"dddd")
 
Well that was easy enough! Thanks a whole lot!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top