Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom date input mask

Status
Not open for further replies.

Saintor

Technical User
Sep 19, 2000
21
CA
I have a date/time to have the following format;
02-11-01 07:29

Format is
yy-mm-dd hh:ss -it works

I set the input mask of my field to
9999-99-99\ 99:99;0;

However I'd like to avoid entering the two first digits of 2002 each time. I would like to enter data as the format.

Modifying the mask has been unsuccessful.

Any idea?
 
I would make the following change:

change 9999-99-99\ 99:99;0; to 00-99-99\ 99:990;0

this will force you to have to enter the year as 01 or 02 or 03 and the rest as you have been....I would also recommend changing the month and day digits, and even time, to 0s also...so you can just type it allin without having to hit the dash character, etc.

so ultimately:

00-00-00\ 00:00;0; Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top