Date Query with formula

  • Thread starter Thread starter van
  • Start date Start date
V

van

Hi All

I am creating a query which involves the use of dates and times. I have a
date in a table, which I am retrieving via the query. However in the query
I would like to use a similiar formula to that used in excel "WEEKDAY" to
return the day number based on the date eg Mon = 1, Sun = 7. Is it possible
to incorporate a formula such as this into a query?

Thanks
 
Check out the DatePart function in ACCESS. It will return a number to you
that corresponds to the day of the week, depending upon which day you decide
to call "Day 1" (you specifiy this as one of the arguments in the function).
 

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

how do I obtain data for Friday & Saturday on a Monday 1
Creating an update query that uses multiple parameters 2
Sorted and Unique Date Period 2
Query for Month and Day against Date() 2
Querying Dates 5
query for attendance 1
calculate date - no weekends 3
Help with 3 scenerio query 1

Back
Top