Setting Due Date

[Scott McDonald]

Hello @fcarmario

I'm reviewing the notes on Parse field for extracting data functionality and it appears that it will work for what I need. I'm looking to populate a Due Date field 2 weeks after the effective date but I'm not exactly sure how what the delimiters would look like. Can you help me with that?

Thank you, Scott

[Fidel Castro Armario]

Hi @scottjmcdonald,

I need a detailed description of your use case. What do you mean by "populate a Due Date field 2 weeks after the effective date"?

[Scott McDonald]

Hello @fcarmario

Upon create; the Due Date of the parent ticket and sub-task tickets shall reflect 2 weeks after the Effective Date.

• Due Date shall be auto-populated
• Effective Date is manually entered at the time of create

Scott

[Fidel Castro Armario]

Hi @scottjmcdonald,

You can do it using "Mathematical and date-time expression calculator" post-function with any of the following formulas:

1. Formula 1 - Adding 14 natural days: {nnnnn} + 2 * {WEEK}
2. Formula 2 - Adding 10 work days: addTime({nnnnn}, 10 * {DAY}, "my_schedule", LOCAL)

replacing nnnnn with field code for Effective Date field.

First formula adds 14 natural days to the date in Effective Date field. The second formula adds 10 work days according to a "custom schedule".

[Scott McDonald]

That worked beautifully!