This topic is locked

IsDate

8/7/2009 1:18:17 PM
PHPRunner General questions
D
drh author

Hello forum,

I almost hate to ask this question since the application in question was created using PHPR 3.1. Here goes anyway. First of all, too large of an application to upgrade to the lastest version of PHPR.
I have two date fields (date only). Date_field_1 is Required, Date_field_2 is not required. In the _add.php and _edit.php programs, Date_field_1 is defined as IsRequiredIsDate. Date_field_2 is defined as IsDate.
If I leave Date_field_2 blank / empty when adding or editing a record, I get the message that the field needs to be a "valid date". How can I fix this up so that the field has to be valid or null?
I tried to set the default value for Date_field_2 to 0000-00-00 in the database, but of course that is not a valid date so I get the valid date message.
I realize that the app is really old and probably not too many folks familiar with PHPR3.1 anymore. Any help would be greatly appreciated.
Thanks,

Dave