Is it possible to do a date field validation using an sql query. Its like we have an html field- its a free form text field and the end user should type in a valid date, of course in a predefined format only (MM/dd/yyy). I tried using javascript but either it works on some browsers and not in others or the user can just disable javascript in eth browser.
SO I was hoping that I can use an sql query (some function in mysql) which will return true or false based on whether the date is in the future, valid (considering leap years etc..) and in the predefined format. Is this possible - is it a viable thing to do - all I want is a foolproof way of validating the date input field. -- Thanks and best regards, Anoop