Tag: trandate

To Add Days To Last Day Of trandate

You can use the below formula in a workflow after the field change of the trandate to add days to the last day of the trandate. (new Date((new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).getFullYear(),(new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).getMonth() ,(new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).getDate()+30)).toLocaleDateString()

Set The Last Date Of Trandate

You can use the below formula to set the last date of trandate in the workflow triggering after a field change of trandate (new Date(new Date({trandate}).getFullYear(),new Date({trandate}).getMonth()+1 ,0)).toLocaleDateString()

ADD 30 days to trandate in workflow

Requirement: Add 30 days to trandate in workflow in a custom field. Solution: Generate a workflow to set the custom date field in the transaction records. Add Set Field Value action to set the value in custom field. Trigger ON: Before User Edit Event Type: All Context: All Select the custom field in Parameters field.… Continue reading ADD 30 days to trandate in workflow