Unanswered: Date issue (dd/mm/yyyy versus mm/dd/yyyy)
I'm having troubles with a datefield in one of my tables.
I created a form with a calendarcontrol on it. In the properties of it I defined that system dateformat (which is dd/mm/yyyy) should be used.
However, after inserting the selected date into my table (datefield defined as short date and even dd/mm/yyyy) my date is :
- in format mm/dd/yyyy if day is smaller or equal to 12
- in format dd/mm/yyyy if day is greater than 12
When I trigger the AfterUpdat-event it shows the correct date.
Even a debug.print of my SQL-stqtement shows me the correct value.
When I select February 12, 2008 it will put 02/12/2008 in my table.
When I select February 13, 2008 it will put 13/02/2008 in my table
Any help / hints would be appreciated. I spent too much time testing and trying, but no success.
It's not a matter of display --> my values are stored in a mixed way depending on the day.
- if day <= 12 then DB seems to be confused which part is day and which part is month --> he will take day as month and moth as day
- if day > 12 then there is no discussion what is month and what is day, so this will be stored correctly
Even putting format(date, "dd/mm/yyyy") in my SQL-statement gives the same issue.