Spotfire week function return non iso week number

Hi to all,

I've got a problem with the week function in spotfire. If I put in the date 2015-12-28 it return week 53 as i would expect. If I put in date 2016-01-01 it gives back week 01 while in fact it is still week 53 (according to iso). The date 2016-01-04 ends up being week 02 according to the week function while iso states this is week 1.

I know the function is depending on regional settings. But is there a way to enforce that the iso date system is used for this function.

I know that excel has a specifier in the week function that you can use to get the setting correct.

 

All help appreciated.

 

greetz Ed Bierens

Login