Changing Date format produces 12/31/1969 for null values

[transcan]

Hello.

When using this delegate to change the date format from YYYY-MM-DD to MM-DD-YYYY, it works for dates inputted and retrieved, however for certain fields that remains blank until a date is entered in the near future, 12/31/1969 is displayed instead of blank. How can this be fixed to show a blank and still show the correct date format of MM-DD-YYYY?

Code: Select all

    function delivery_date__display(&$record){
        return date('m/d/Y', strtotime($record->strval('delivery_date')));

Thanks in advance.

[shannah]

Evidently strtotime($record->strval('delivery_date')) is returning 0.
Try just changing this to:

Code: Select all

function delivery_date_display(&$record){
    return $record->strval('delivery_date');
}


to see what it gives you. Likely it is giving you an empty string which means either you have a typo, or the record has no date set.

-Steve

[transcan]

Yes, the function works. Thanks.