Date Validation
Date Validation
When I prompt a user to input a date into my database I would prefer if they only used the calendar to pick the date, although most people do this and the date format works perfectly well. If they used the calendar for today I get returned a perfect date format 22-Jan-2008 appearing in my database. However some are typing the date themselves in the often used shorthand version format of 22/1/08 and the database is populated with 22-Jan-0008.
Is there a way I can force the user to only use the calendar to select the date i.e. disabling the ability to type in a date or a shorthand date? Or do I need to start validating the date input using scripting. If the latter is the case some ideas on input date validation would be most welcome.
Thanking you in advance.
Vince