Pulling created date from Jira into Confiforms field (read only or date) not working

[Miriam Cohen]

Hello Everyone - this is my first post.

I have been working with Confiforms for about a year and half. Greatly appreciate this community which has helped me ramp up very quickly to produce very useful forms.

I am interested in being able to perform calculations using date fields but the information is not being loaded.

Originally for visibility only, I was loading several fields from a jira task into several confiforms read-only fields. Loading from a jira "custom" date field (customDate) works correctly using the ConfiForms Rules for Field Definition with the "Values to set":

• CfFieldA =[entry.JiraIdField.fields.customDate]

However, when trying to load from the jira "native" date field (created), since this did not work

• CfFieldC =[entry.JiraIdField.fields.created]

I also tried these options, none of which worked either:

• CfFieldC =[entry.JiraIdField.fields.created.jiraDate]
• CfFieldC =[entry.JiraIdField.fields.created.parseDate(yyyy-MM-dd'T'HH:mm:ss.SSSZ).formatDate(yyyy-MM-dd)

Ultimately, keeping in mind I want to be able to perform calculations using the date information. I also tried redefining the fields as Date, but in that case the customDate field would consistently load a negative number (-9223372036854775808), regardless of the actual date in jira. 

What would be the correct syntax for Values to set?

[Alex Medved _ConfiForms_ · Accepted solution]

If you want to copy the "created" field from Jira issue and set it to the datetime field in ConfiForms you can do something like

CfFieldC=[entry.JiraIdField.fields.created.parseDate(yyyy-MM-dd'T'HH:mm:ss.SSSZ)]

And as always, you can access it directly through the Jira field any time, just by having a ConfiForms Field macro with a field name parameter set to 

JiraIdField.fields.created

Alex 

[Miriam Cohen]

This worked - thanks @Alex Medved _ConfiForms_ 

CfFieldC=[entry.JiraIdField.fields.created.parseDate(yyyy-MM-dd)]

NOTE: I had to remove the portion starting at 'T' and after, because my field is a Date field, not a DateTime.