Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Pulling Insight date attribute into an issue

Robert Smith March 4, 2022

Hi All,

I'm using insight to store contracts for my procurement team.

I've made an automation that checks the 'review ticket creation date' stored in insight, and if it's today, create a review ticket for it.

Annotation 2022-03-04 151338.png

When a review ticket is created it takes the contract name and review date, and puts it in the ticket.

I can get the date to output into a text field, but not my custom date field. I've tried a lot of date formatting options (like .toDate(yyyy-MM-dd) ) but nothing works.


Does anyone know what I'm doing wrong?


Many thanks,



2 answers

1 accepted

0 votes
Answer accepted
Robert Smith March 10, 2022

I've found a workaround for this.

First, you have the automation set the Insight date into a text box.

Annotation 2022-03-10 102842.png

You then have a seperate automation that runs just afterward.

  1. It takes all issues created today
  2. Copies the date from the text box to the date field
  3. Clears the text boxAnnotation 2022-03-10 103150.png

I hope this helps anyone else with this niche problem.

0 votes
Kai Becker
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 4, 2022

Hi @Robert Smith ,

what is the output format of the insight field value?
Because that needs to be the format you put into *toDate()* function.

Then you will get a date object, that you should be able to format further.

Robert Smith March 10, 2022

Hi @Kai Becker

Thanks for the suggestion

I've tried that, with no luck.

I've found a workaround though.

I've put the date from insight into a text box.

I then use a seperate automation that runs at 0630 to copy the value from the text box to the due date, using the .toDate function.

I don't like that I have to use this workaround, but at least it works.


Like Kai Becker likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events