Hi,
I have just run into the classic date format problem and do find the solution that i used to have found.
Entering data with sql into table.
When default date field is =Date(), the format of the date is correct as it is set by w10 (UK)
When i choose the date from the date picker the format is correct only if the day number is higher as the month. If it smaller the day and the month mixed up.
I have tried to fix in vba by adding Format([DOV], "\#mm\/dd\/yyyy\#") wher DOV is the name of field.
How do i solve it, what do i do wrong?
thanks
I have just run into the classic date format problem and do find the solution that i used to have found.
Entering data with sql into table.
When default date field is =Date(), the format of the date is correct as it is set by w10 (UK)
When i choose the date from the date picker the format is correct only if the day number is higher as the month. If it smaller the day and the month mixed up.
I have tried to fix in vba by adding Format([DOV], "\#mm\/dd\/yyyy\#") wher DOV is the name of field.
How do i solve it, what do i do wrong?
thanks