ADD 30 days to trandate in workflow

Requirement: Add 30 days to trandate in workflow in a custom field.

Solution:

1. Generate a workflow to set the custom date field in the transaction records.
2. Add Set Field Value action to set the value in custom field.
   • Trigger ON: Before User Edit
   • Event Type: All
   • Context: All
3. Select the custom field in Parameters field.
4. Check Formula radio button and add the following formula to add 30 days to trandate:

nlapiDateToString(nlapiAddDays(nlapiStringToDate(nlapiGetFieldValue('trandate')),30),'date')

Workflow:

Output: