This topic is locked

Validation on Date Fields

5/31/2009 12:36:13 PM
ASPRunnerPro General questions
M
mows author

Hi,
We're still running with version 6.0. Am not sure if this has been resolved in 6.1.
We've several items on a form where the underlying column is a DateTime data type and within the Visual Editor the `edit as` is set to Date.
We've set one of the items to be mandatory so that a date must be entered. Have found users can sneak around this requirement by entering `00` into the date field. This allows them to enter a blank date regardless the items be set as a `required field`.
Is this improved in 6.1 ?
Also have found that if Feb 29th is entered in a non leap year the error message is simply `type mismatch`. Could this error message be a little more meaningful.

  • Judd

J
Jane 6/1/2009

Hi,
in ASPRunnerPro 6.1 you can set up custom validation and validate date fields manually.

Also you can check entered values in the Before record added/updated events on the Events tab and show error message if needed.