Im having problems when using Dates in SQL statements. Im using an Access DB. Im trying to find the records that are between a Week Commencing and a Week Ending Date. e.g. this week would be 01/04/02 to 05/04/2. However when I try using these in my SQL statement it doesnt return any records (or throw any errors). Is this because they need to be converted to US before they are used in the SQL? I dont want to hard-code any dates into the SQL so i need a method (?!) which can take the current date and calculate the week commencing and week ending dates.<BR><BR>Could someone show me an example of how to do this?