project automation for date

Question

Does anyone know the formula to convert QTR Start (issue type Initiative) to start date to help build Gantt and Plan timelines?

I have something like this, but don't see it working:

When value changes:
  QTR Start
Then edit issue field:
  Start date
  {{issue.qtr_start.plusDays(18)}}

Mike Joyce · Answer

What we tested and found to work was the need to break this into two steps.

1. Edit 'Start date' with  {{issue.qs}}

--  just for good measure fetch 1 sec delay

2. Edit start date with   {{issue.Start date.plusBusinessDays(5)}}

and that worked very well.

Duc Thang TRAN · Answer

@Mike Joyce

When it makes a log action with this smart value {{issue.qs}},what is returned? Maybe {{issue.qs.plusDays(5)}} doesn’t work because that is not a date value and can’t be combined with this.I’m sharing a few things I’m using that may help you, but they need to be adapted to your context.

Convert a text field to date time value

Create variable  : Datetime with  smart value  {{issue.comments.last.body.substringBetween("Date Time :","Email :")}}

Convert to date time value :

Mike Joyce · Answer

also...  in using {{issue.qs}}   that works.   Trying  {{issue.qs.plusDays(5)}}  does not unfortunately.