If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Query with formula
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 |
#2
|
|||
|
|||
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). -- Ken Snell MS ACCESS MVP "van" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Financial Comparison | Steven Cheng | Setting Up & Running Reports | 13 | November 26th, 2004 10:59 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Using Start Date and End Date in Query | ChuckW | Running & Setting Up Queries | 5 | July 20th, 2004 02:52 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |