Populating Form Date Field Control with MySQL Query Field?
Posted: Tue Dec 14, 2010 6:42 am
Note: All dates are of MySQL Type DATE
Now when I display the results of this field in my query in a date field control in a form in Base,
The control always displays as: 01/01/1800
...dispite that when I run the query outside of the form I get a result of TheNextDate: 12/14/2010 (when the next_date field isn't NULL).
Does this have something to do with the way the field is being returned, and the way the field is being returned?
I have some other Date Field controls that are filled in by other fields in the same query and they appear correctly...
for instance something as simple as:
appears just fine.
Code: Select all
IF( ISNULL( `job`.`next_date` ), DATE_FORMAT( ADDDATE( `job`.`last_date`, 36 ), '%m/%d/%Y' ), DATE_FORMAT( `job`.`next_date`, '%m/%d/%Y' ) ) AS `TheNextDate`
The control always displays as: 01/01/1800
...dispite that when I run the query outside of the form I get a result of TheNextDate: 12/14/2010 (when the next_date field isn't NULL).
Does this have something to do with the way the field is being returned, and the way the field is being returned?
I have some other Date Field controls that are filled in by other fields in the same query and they appear correctly...
for instance something as simple as:
Code: Select all
DATE_FORMAT( `job`.`last_date`, '%m/%d/%Y' ) AS `LastContactDate`