Substitution KEY __DATE_DELIVERY__ return null

[Pic-Event]

Bug

Hello,
you need to change the line 8265 in htdocs/core/lib/functions.lib.php

Change

$substitutionarray['DATE_DELIVERY'] = (isset($object->date_delivery) ? dol_print_date($object->date_delivery, 'day', 0, $outputlangs) : '');

To

$substitutionarray['DATE_DELIVERY'] = (isset($object->delivery_date) ? dol_print_date($object->date_delivery, 'day', 0, $outputlangs) : '');

And all the times date_delivery is used in PROPAL,.

Thanks.

Dolibarr Version

19.0.1

Environment PHP

All

Environment Database

Mysql

Steps to reproduce the behavior and expected behavior

Try to used the KEY DATE_DELIVERY in email templates.
It return all the time nothing.

Attached files

No response

[Pic-Event]

Please could you correct this bug ?

Dolibarr 9.0.3

you need to change the line 8283 in htdocs/core/lib/functions.lib.php

$substitutionarray['DATE_DELIVERY'] = (isset($object->date_delivery) ? dol_print_date($object->date_delivery, 'day', 0, $outputlangs) : '');

by

$substitutionarray['DATE_DELIVERY'] = (isset($object->delivery_date) ? dol_print_date($object->delivery_date, 'day', 0, $outputlangs) : '');

Thanks

[jman482002]

Hello @picarcyr
I tried your fix by changing to:
$substitutionarray['DATE_DELIVERY'] = (isset($object->delivery_date) ? dol_print_date($object->date_delivery, 'day', 0, $outputlangs) : '');

This did not work for me. Can you explain what else I need to do to get this working?

Thanks

Also not working in Sales Orders module.

[jman482002]

Figured it out. You must change it in both places for every line:
$substitutionarray['DATE_DELIVERY'] = (isset($object->delivery_date) ? dol_print_date($object->delivery_date, 'day', 0, $outputlangs) : '');

[priojk]

Fixed by #32507, also for the other substitution variables related to DATE_DELIVERY for _DAY, _MON, _YEAR etc.