Input mask for short date please 1

[jwkolker]

Hi there - for some reason my install of 2000 doesnt have the full install and I am unable to use the inputmask wizard to set the input mask to short date - does anyone know the manaul settting? The examples in access are helpful but there is not one for short date - I need the WHOLE thing including the cursor def.

Thanks,

John Kolker

John Kolker
Programmer
jwkolker@comcast.net

 

[RoyVidar]

Hi!
00/00/0000;0;_
Roy-Vidar

 

[mnongkhlaw]

Hi,

I'm using Access 2000 with the above input mask and short date format. British dates like 01/02/2003 (1st Feb, 2003)entered thru a web page's textbox bound to date/time field gets converted to 02/01/2003 in the table, but dates like 20/01/2003 (20th Jan, 2003) get stored correctly. My Regional Options (Win2000 server) settings :-

Locale : English (US) OR English (UK)
Short date format : dd/MM/yyyy

What is the problem and how can I resolve it? I want to store dates in british format only.

Mark