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

Question

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!

Johnson Wang_ix7d2q · Answer

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:

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;};/*Call this script from a workflow transition post-function.

Hope this helps!

Johnson