Help with Jira assets bulk upload

[James Gaiser]

Hello I am trying to update data from a CSV into jira assets. I have a few entries that are dates. When it does the mapping for the attribute it makes them a text type so I cant do an AQL query to search the dates in a range. How do I set it up so it recognizes it as a date at the time of upload?

[Mikael Sandberg · Accepted solution]

Hi @James Gaiser,

Welcome to Atlassian Community!

Make sure that your date is following the expected format, MM/dd/yyyy. Have a look at this KB for more information on how to prepare your data for import to Assets. 

[James Gaiser]

Hello Mikael. Thank you for the welcome!

It is in that format. Should it auto detect it as a date or is there something else I need to do so it is created as a date type object?

[Mikael Sandberg]

Is the attribute in the Object schema defined as date?

[James Gaiser]

Hey Mikael I was away at the end of last week. It is not. Is there a way I can configure that at time of upload? In normal jira I decide that when I create the custom field but I cant find the option to do it here.

[James Gaiser]

Hey I got it working thank you!