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