How to add a DATE type custom field as a column to a schema

Mariah Ferreira Do Prado Rottoli

Hello!

I´m starting to explore Atlassian Analytics in our main instance, and I´ve been having some issues.
I am trying to add a project´s custom field ('End date') as a column in a schema but I´m unable to set the Type of it. It is a date field but it keeps showing it as a string instead:

 

Is there a way to change it to date? Or do I have to add this custom field in a different way?

Thanks!

Leonardo Barrios_yr1x95

Hello Mariah,

Thank you for contacting the Atlassian community! I am Leo from Atlassian Team.

You may perform this change directly when querying this data on Visual SQL section.

To be able to do that, you are going to use the 'CAST' custom formula. In your case, your formula should be something like:

CAST("End date" AS date)

You are going to have your formula column as date, and then you will be able to query your date using this column.

You also may take a look at this article that could give you a better understanding:

Change a data type with Visual SQL steps | Atlassian Support | Atlassian Documentation
Use custom tables and columns | Atlassian Analytics | Atlassian Support

I hope this information helps you!

Best regards,
Leonardo Barrios
Support Engineer