Problems with the date format for properties

I am trying to add a custom property as a date(time). As the documentation states the expected format is:

[YYYY]-[MM]-[DD]. The expected date time format is [YYYY]-[MM]-[DD]T[hh]:[mm] with an optional offset from UTC of +/-[hh]:[mm] or Z for no offset.

Yet, when I add a value to a date property like this: "firstCommentAdded":"2021-05-15T13:44+02:00", the property is not accessible or indexed with JQL.

For reference, this is my manifest entry:

- path: firstCommentAdded
  type: date
  searchAlias: firstCommentAdded

Other types and values specified within the manifest work as expected.

Can you point me towards an error in the way I provide the value or which other pattern I should try?

1 Like

Hi @GideonNolteJodocus, thank you for reaching out! Sorry for late response, for some reason I missed your message.

I believe the problem is that you missed seconds part in your datetime value. It should be:
"firstCommentAdded": "2021-05-15T13:44:11+02:00"

We have to fix our documentation, since as you pointed out, it suggests incorrect format.

The expected date time format is [YYYY]-[MM]-[DD]T[hh]:[mm]:[ss] with an offset from UTC of: +/-[hh]:[mm] or Z for no offset.

I’ve tested it and it works as expected.

Best regards,
Łukasz

2 Likes