Access Date comparison Problem

[amolbehl]

Hi I am trying to use the following query to get all dates in a particular range please let me know wht I am doing wrong

SELECT Unique_Sets_Bulk.CustomerNo, Unique_Sets_Bulk.OrderDate, Unique_Sets_Bulk.RouteNo
FROM Unique_Sets_Bulk
WHERE (((CDate([OrderDate]))>="#1/1/2005#" And (CDate([OrderDate]))<="#12/1/2009#"));
 
 

[Delerna]

Nothing obvious stands out
Try putting the CDate(orderDate) into your select fieldlist and see
that it is in the correct format for the comparison to work

[missinglinq]

WHERE (((CDate([OrderDate]))>="#1/1/2005#" And (CDate([OrderDate]))<="#12/1/2009#"));

I think you need to lose the quotation marks around the dates, they're turning your dates into strings. Date literals are delimited by the pound sign alone.

Linq ;0)>

[ADezii]

Hi I am trying to use the following query to get all dates in a particular range please let me know wht I am doing wrong

SELECT Unique_Sets_Bulk.CustomerNo, Unique_Sets_Bulk.OrderDate, Unique_Sets_Bulk.RouteNo
FROM Unique_Sets_Bulk
WHERE (((CDate([OrderDate]))>="#1/1/2005#" And (CDate([OrderDate]))<="#12/1/2009#"));
 
 

SELECT Unique_Sets_Bulk.CustomerNo, Unique_Sets_Bulk.OrderDate, Unique_Sets_Bulk.RouteNo, CDate([OrderDate]) AS Converted_Date
FROM Unique_Sets_Bulk
WHERE CDate([OrderDate])>=#1/1/2005# And CDate([OrderDate])<=#12/1/2009#;

[amolbehl]

Yup It works ... thanx a lot