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`