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!

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,

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,