Query by Date on formatted date column is not working

[nyneave]

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

[pbaldy]

Try without the Format() function. It changes the output to text.

[nyneave]

Perfect...thank you so much!

[pbaldy]

Happy to help!