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?