Pulling Insight date attribute into an issue

[Robert Smith]

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.

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,

Robert

[Robert Smith · Accepted solution]

I've found a workaround for this.

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

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 box

I hope this helps anyone else with this niche problem.

[Kai Becker]

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]

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.

Robert.