This topic is locked

Date Validation Not happening

7/30/2011 5:37:30 AM
PHPRunner General questions
I
imthebest author

I am using a date field in Add Page and have used "Simple Edit Box with date picker" option. I did not make it required field. Hence, the requirement is that either the date can be left blank or if added should be a valid date.
I noticed that if a user does not enter a valid date, then also record is getting saved with date as 00-00-0000. Ideally, system should validate the date and through the error message.
Anyhelp, if I am missiong something, whey date validation is not happening?

B
BigO 7/30/2011

Check ur DB if the date field is set to date...

I
imthebest author 7/30/2011



Check ur DB if the date field is set to date...


Yes, Offcourse. The field in DB is set as DATE only.

However, the date validation should happen at client level first, which is not happening.

The date is getting saved in DB as 0000-00-00, in case if user enters invalid date.

I
imthebest author 8/2/2011



Yes, Offcourse. The field in DB is set as DATE only.

However, the date validation should happen at client level first, which is not happening.

The date is getting saved in DB as 0000-00-00, in case if user enters invalid date.


Any Help on this, please? Why date validation is not happening?

I
imthebest author 8/2/2011

I am still waiting for help on this..

Please, any one who knows the solution, kindly help.

Sergey Kornilov admin 8/3/2011

There is not enough info.
I recommend to contact support directly providing access to your files and database.

I
imthebest author 8/4/2011

I think the query is straight forward.
Let me explain once again.
There is a field on Add Page, which I selected as type "Date" in visual Editor. I selected "Simple Edit Box with date picker" option.

This is not a "required field." The requirement is that either the date can be left blank or if user adds the date then it should be a valid date.
I noticed that if a user does not enter a valid date, (for example, if he enters some junks like 78738120) then also record is getting saved in database with date as 00-00-0000. Ideally, system should validate the date and throw the error message, before saving to database.
Hope, I am clear with the issue.
Please advice, if I need to select any option for date validation to be performed.
Thanks in advice.

Sergey Kornilov admin 8/5/2011

You need to contact support directly providing access to your project files.