I am using Access 2003 - I have a linked table that was xml data so all columns are text data type. However, the actual data in a few of the columns such as Date_of_Birth are date values. I need to be able to query by these values so I am first doing the following on the column:
DOB: Format(CDate([DATE_OF_BIRTH]),"mm/dd/yyyy")
Then in the criteria, I am using > #12/31/2009#
It is returning all data, all dates. Can anyone help?
Thanks,
Nyneave