TIBCO Spotfire : How to change dates

[LE GENDRE Aurlien]

Hi Everyone, I have 2 questions about dates on TIBCO Spotfire : 1) On my Excel data base, I have dates in "US format" (yyyy/mm/dd), and I would like to change them in "French Format" (dd/mm/yyyy) on Spotfire. I tried to change them in Spotfire, but some empty dates. 2) On another data base, I have dates like this "yyyymmdd", and I would like to change them quickly in "dd/mm/yyyy". Thank you in advance for your help. Aurlien

[Kirsten Smith (she/her)]

Dates in Spotfire are formatted using the Region settings on your computer. If you go into Control Panel and set the Date Format to French, then all dates imported into Spotfire will be formatted the way you have described.