deepbreath
05-25-2001, 04:06 AM
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
|
View Full Version : date format deepbreath 05-25-2001, 04:06 AM 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 05-25-2001, 04:39 AM 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 05-25-2001, 06:31 AM 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 05-25-2001, 08:21 AM Check your Regional settings in the Windows Control Panel and make sure the Date settings are set to your country. HTH |