D deepbreath Registered User. Local time Today, 11:47 Joined Apr 18, 2001 Messages 73 May 25, 2001 #1 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
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
C charityg Registered User. Local time Today, 11:47 Joined Apr 17, 2001 Messages 634 May 25, 2001 #2 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.
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.
D deepbreath Registered User. Local time Today, 11:47 Joined Apr 18, 2001 Messages 73 May 25, 2001 #3 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?????
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?????
K KevinM Registered User. Local time Today, 11:47 Joined Jun 15, 2000 Messages 719 May 25, 2001 #4 Check your Regional settings in the Windows Control Panel and make sure the Date settings are set to your country. HTH
Check your Regional settings in the Windows Control Panel and make sure the Date settings are set to your country. HTH
