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 · Accepted solution]

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

[Mariah Ferreira Do Prado Rottoli]

Thank you, @Leonardo Barrios! Your solution worked, but I did encounter other issues with other parts of the chart. I probably did not choose the best template for what I need, so I´ll try other ones.
Thank you!