date format (1 Viewer)

[deepbreath]

i have a date field, which i have format of dd-mm-yyyy. but the problem is when i enter date it converts into american format. puzzled

 

[charityg]

Do you have the format in the table design. Formatting a form field is only for display purposes, you need to apply the formatting to the field properties in the table design.

 

[deepbreath]

yes dd-mm-yyyy is in table and form, but it doesn't work, if i enter 12-4-00, it writes is as 4-Dec-2000?????

 

[KevinM]

Check your Regional settings in the Windows Control Panel and make sure the Date settings are set to your country.

HTH