Hi all, I have a table that has among other fields the following two fields:
1.) TimeCreated - this is a date/time field - sample data "12/4/2006 9:10:43 AM"
2.) ListID - this is a unique customer identifier - sample data = "AB1234"
I am trying to run the following query
SELECT Customer.ListID, Format(Customer.TimeCreate
d,"mm/dd/y
yyy")
FROM Customer
where Format(Customer.TimeCreate
d,"mm/dd/y
yyy")>"01/
01/2006" ;
The idea of the query is to get a list of all the customers who were entered into the system after 1/1/2006. The query runs but the results contain all the records, even records created prior to that date. What is wrong with the query above? Any help would be appreciated.
Thanks,
Ram.
Start Free Trial
