Hello everyone!
I'm trying to set a custom ship date field for purchase orders - since products on the same PO can have very different lead times, I have a field to set the expected ship date for each line. I also have a custom field for lead time, in days, which is pulling the lead time from the item record.
I can set the ship date field via the workflow if I use the join(current record) and a field (date), but not if I use a formula, even if the formula is simply {trandate}.
This works:
This does not:
I've also tried the formula {today}, to_date({today},'M/D/YYYY') (the format in my user preferences), to_date({today}) and to_date({trandate}). I get the same error with each:
I have also tried using the field defaults in the custom field -
This works:
But this does not:
and results in an empty field. I assume that would be because the lead time field has not sourced its value before the ship date field calculates its value.
Here is the custom field I'm trying to set the value for:
And the field I'm trying to add to the transaction date:
Here is the workflow information:
I've also tried to update this field with the "after field sourcing" trigger, triggering on the lead time field, but the field remained blank.
How can I set the date to be equal to the transaction date + the leadtime?