Peculiar date problem

[kksingh]

I've a form with 'Unbound' text boxes with 'Format' & 'Input Mask
defined as 'Short Date' i.e. dd/mm/yyyy
Similarly, in the table, the date fields are defined as 'Date/Time'
'Format' & 'Input Mask' as 'Short Date'
My problem is that when I insert the data into access table usin
'DoCmd.RunSQL SQLString', dates from 13-30 are stored properly in th
database as dd/mm/yyyy while the remaining dates from 01 to 12 ar
stored in the table as mm/dd/yyyy

(I'm using MS Access 2002 SP3

 

[Brendan Reynolds]

I've a form with 'Unbound' text boxes with 'Format' & 'Input Mask'
defined as 'Short Date' i.e. dd/mm/yyyy.
Similarly, in the table, the date fields are defined as 'Date/Time',
'Format' & 'Input Mask' as 'Short Date'.
My problem is that when I insert the data into access table using
'DoCmd.RunSQL SQLString', dates from 13-30 are stored properly in the
database as dd/mm/yyyy while the remaining dates from 01 to 12 are
stored in the table as mm/dd/yyyy.

(I'm using MS Access 2002 SP3)

See Allen Browne's explanation of dates in Access at the following URL ...

http://allenbrowne.com/ser-36.html