Convert a date into the Weekday

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I make the weekday show up in a query where I have the date already?
 
Add a new column to your query and put the following in it.


DayOfWeek: Format([SomeDateFieldName, "dddd")



William said:
How do I make the weekday show up in a query where I have the date
Click to expand...
already?
 
Rick B you are the man!

Rick B said:
Add a new column to your query and put the following in it.


DayOfWeek: Format([SomeDateFieldName, "dddd")



William said:
How do I make the weekday show up in a query where I have the date
Click to expand...
already?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query for Month and Day against Date() 2
Sorted and Unique Date Period 2
SelectCase statement 5
WeekDay Order in Month 2
date time range criteria 2
Calculating weekdays in Access 5
how do I obtain data for Friday & Saturday on a Monday 1
Reduce # of date columns in crosstab query 4

Back
Top