I have a custom due date field on my sales order.
...
# suiteflowa
Artur_K
01/14/2022, 11:04 AMI have a custom due date field on my sales order.
The calculation is triggered on when the customer is chosen.
Unfortunately this formula doesn's seem to work.
nlapiDateToString(nlapiAddDays(new Date(nlapiGetFieldValue('custbody_aim_due_date')),14))
Any suggestions? thanks
a
AI1
01/14/2022, 1:20 PMAre you attempting to do this via a workflow action? Like set field value action?
a
Artur_K
01/14/2022, 1:21 PM@AI1 yes exactly, the trigger is after field edit in the workflow, but the formula doesn't give the the calculation I'm looking for
a
AI1
01/14/2022, 1:25 PMUsually the formula {custbody_aim_duedate} + 14 works in a workflow
AI1
01/14/2022, 1:26 PMWell usually for adding days to a custom date field. If you try to set a native date field this way it gives you a format error
a
Artur_K
01/14/2022, 1:37 PM@AI1 The whole logic for the dates is following: Issue Date + 14 = Due Date
I applied this SQL formula: {custbody_issue_date} + 14
issue date was e.g. 14.01.2022
result due date was 14.01.2022, too. Didn't apply the + 14
a
AI1
01/14/2022, 1:45 PMIs the issue date always today?
Also if you try making the trigger after record submit does it calculate properly?
a
Artur_K
01/14/2022, 2:01 PMby default, but the employees might change it. So after record submit wouldn't be optimal. Sometimes the due date is in the past due to company policies
Artur_K
01/14/2022, 2:01 PMAnd i want them to change it before saving
Artur_K
01/14/2022, 2:02 PMI get a result but in the wrong format when I use this function:
nlapiAddDays(nlapiStringToDate(nlapiGetFieldValue('custbody_issue_date')), 5)
Artur_K
01/14/2022, 2:03 PMThis is the date result:
Wed Jan 19 2022 000000 GMT+0100 (Mitteleuropäische Normalzeit)
Artur_K
01/14/2022, 2:03 PMIs it possible to format the result to D/M/YYYY?
a
AI1
01/14/2022, 5:18 PMCan you put TO_DATE( (formula), ‘D/M/YYYY’) around that entire formula?
a
Artur_K
01/14/2022, 8:28 PMUnfortunately this resultet into an infinite loop
3 Views