Dear Richard,

Time index 14:35
I am struggling with a situation when a user does not enter a valid date. I have tried using On Error Resume Next. The error gets ignored but the record does not get written into the table.

Please advice me what i can do.
Thank you!
MICAH

---

Reply from Richard Rost:

Well, first make sure there's something in the field. Then specifically convert it to a DATE value and make sure it's within a valid date range. I do something like this:

MyDateTxt = request("MyDateField")
If MyDateTxt = "" then response.write "INVALID DATE"
MyDate = CDATE(MyDateText)
if MyDate < #1/1/2001# or MyDate > Now() then response.write "INVALID DATE"

Something along those lines.