Post function to set date field to X days from transition date?

Ron December 8, 2017

I'm trying to create post function that will set a date field (date only, not date and time) to X amount of days from the transition date.

While configuring, there's an info message that states: "You may use macro '%%CURRENT_DATETIME%%' to insert the current date and time." But my field is a date only and I'm interested in setting a date that is X days from the transition date/current date.

Any tips on what to enter in "Custom Field Value"? Thank you!

1 answer

0 votes
Johnson Wang December 11, 2017

Hey @Ron,

If you're open to trying add-ons, I'd recommend using something like Power Scripts.

Here's an example video guide and script of a similar kind of setup for automatically calculating the due date based on a custom field value.

If you're familiar with coding, it should be pretty straightforward to modify this to your needs:

/*Call this script from a workflow transition post-function.It will set the due date based on the value of customfield 10703.*/ if(isNotNull(customfield_10703)) {    interval i = (string)customfield_10703 + "d";    dueDate = currentDate() + i;};

Hope this helps!

Johnson

Suggest an answer

Log in or Sign up to answer