|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread |
Rating: 
|
Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
October 1st, 2003, 11:50 AM
|
|||
|
|||
Between Dates in Query
I have linked via ODBC connection to some DDF files from our production software. I am trying to make a query that will limit the records to only the current year. I have tried using the "Between DateAdd("m",-9,Date()) And Date()" and other variations of this "Between' function. I have also dried using the DateDiff("d",#1/1/2003#,Date()) and having the [ORHDRH.Orddate] field > 0 and also using the "Between" function. But I still have no success. I am still getting records that are from previous years. Any suggestions please!
|
|
#2
October 1st, 2003, 07:28 PM
|
||||
|
||||
|
Can you post a sample db with some data. I would like to see how the date [ORHDRH.Orddate] that come over is formatted.
Regards,
__________________
Regards, John A
|
|
#3
October 1st, 2003, 07:55 PM
|
||||
|
||||
|
Have a look at the sample database, I have example of extracting the year and month from a date. Have a look at the queries in the db.
Regards, 
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Between Dates in Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
