Link to home
Start Free TrialLog in
Avatar of jiayiloo
jiayiloo

asked on

Date Data Entry(Immediate)Verification

I created a field with data type "TIME" and it is Editable for user to key in date value(MM/DD/YY).
If user key in wrong date data ie: 12/32/1999 or 13/01/1999 or a2/b1/1999 or "abc" anything that is non-Date format;
What is the best way to immediately(b4 going to next entry field)prompt user that the date having wrong format??
Thks...
Avatar of ghassan99
ghassan99

place this in the validation event of the field, the field must be of type time:
@If(@IsError(@Date(fieldname)); @Failure("error message"); @Success)
if u want to be tested immediately, set the form property 'Automatically refresh fields'
Avatar of jiayiloo

ASKER

Ghassan,
U R right it won't work imediately until I set the form property to 'Automatically refresh fields'.
However I have six Date fields in the form. The user need not necessary fill in all of them and some need to hide base on input criterias....
I suspect the following error message come from these fields that contain your formula.
"Field Contains Incorrect Value"
"field didn't pass validation formula"
Anyway to solve this?? Thks in advance...

Some need to It looks like
ASKER CERTIFIED SOLUTION
Avatar of ghassan99
ghassan99

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial