Hi all

In South africa we use the date format dd/mm/yy
My regional settings are set to this format
My problem is that in my VB app the user must be able to search for soemthing by its date.
I have five records with the date #12/09/00#
When I search 12/09/00 it finds no records
I use SQL to do the search. (MS ACCESS 97)
What access seems to do is swop the date in the actual SQL query to 09/12/00 -- ie. mm/dd/yy
This is despite the fact that the records get saved in the dd/mm/yy format
anyone know why access does this or how I can get it to not swop the format??

the query part is

"where ((prEmergency.date) =#" & txtDate.Text & "#)

Thanks in advance