Searching by date
I have a simple program that fetches some dates from datetimepickers, and then sends them to MS access to do a search by date, Now the problem is that despite having every setting I can find set to Australian Time format, access always seems to search by Month/day/Year (American format) as apposed to Day/Month/Year (Australian format). All my international settings are set to Aus, C# and Access both correctly display in the australian format, yet when I run a query it prioritises Month over day, meaning that if data is enterd 2/6/1997, being 2nd of june 1997, it will search as though it was 6th of Febury 1997, as you can imagine, this results in worthless information.
This is probably not C# fault, so this may be the wrong forum, but it also may be C#'s fault. Both C# and Access seem to work fine and dandy with the correct time formats, except when i inject the data through C# into access.
So where is it going wrong? and How can I fix it? thanks.
