Hi There
I am trying to set the due date on a transaction so that it is equal to the end of the month + 30 days.
The 'end of the month' is calcualted in relation to the transaction date.
I am trying to do this using a workflow so that it the due date is set after the user edits the date field (field id: trandate—this is the native date field).
I am using 'helper fields' to extract the month value of the trandate and to add 30 days to it.
How do I set this up so that:
- The month if extracted from the date field once the user edits the date (I assume this is an after field edit action)
- Helper field 1: updates with the month value
- Helper field 2 updates with the date representing the last day of the month of helper field 1
- Helper field 3: updates with a revised calculated date of helper field 2+ 30 days
thanks