date input mask

[djwasim]

Hello Everyone

these days i am facing a problem in date field of my database form

the problem is that when i enter the date in date field, i am using to enter date as.

02/25/09 that show me result as 25-jan-09

but now i want to enter date as.

25/02/09 that would show me the result as 25-jan-09
But all in vein

Plz tell me that How is it possible?

plz reply me as soon as possible.

thanks
Wasim Shahzad
Pakistan

 

[CameronM]

The input mask only controls the number and type of characters the user must enter into a field. For example, the date expect 2 digits, 2 digits then 4 digits. The input mask does not know if the first set of two digits represent the month or the day of the month, this is set via the Windows Regional Settings.

All is not lost, you can control how the date is displayed on forms by setting the Format property to dd/mm/yyyy.

 

[djwasim]

Thanks for reply
but can u tell me that which regional setting shows that result?

 

[khawar]

You can use United Kingdom

 

[djwasim]

but if is this possible that i use united kingdom then my previous data which i have entered will be disturb?

 

[djwasim]

i dont know that how can i change the regional setting.
can u tell me the procedure?

 

[CameronM]

It is a Windows setting, so it depends on your version, but for XP it is in Start -> Settings -> Control Panel -> Regional and Language Settings. You will need to change the 'Standards and formats' option to a country that supports dd/mm/yyyy - for example UK or Australia.

 

[CameronM]

You should not find any issue with dates already stored in your database, because it really is only for display purposes.

 

[djwasim]

Ohh thanx buddy
Thanx alot