How can I change a date

Hi to all

I hace a date in my DDBB, 12/2/2018. In Spain, means the 12 of February of 2018. However, Spotfire reads it like 2 of December 2018. Also If the date is 15/02/2018. Gives me an empty value because the is no 15th month.

I tried to change the category of the column, Date Time, Date, Integer... custom it, and all I got was appear 2/12/2018 instead the original one 12/2/2018 but continues reading the 12 like month.

 

How can I choose a configuration in this data to fix it?

 

Thank you and regards

(1) Answer

Login