Date Format

[Sam Pena]

Hello. I'm new to Spotfire (as you will see by my easy question). Our accounting software will only export the date column in "YYYY/MMM" format, for example, "2019/011" for November 2019. Spotfire will only accept this "2019/011" as String data.

Is there a way to convert this string data column into a date format within Spotfire

Thank you very much

[Fabian Duerr]

You can either transform this column during load or inside your analysis, oryou add a calculated column.

You can use this formular:

Date(Integer(Left([DateCol],4)), Integer(Right([DateCol],2)),01)So you take the first four letters as YEAR, the last two letters as MONTH, and 01 as DAY.

These are the arguments that the Date() function needs. Like Date(2000, 01, 01) -> 01/01/2000

[Sam Pena]

It worked. Thank you so much!!!