DateTime format is changing from Spotfire analyst to web version

[PBR]

Hello,

I am using Spotfire Analyst 12.0.4 with the DateTime format 'yyyy-MM-dd h:mm tt'.
However, when I save a copy as a library item and open it in a web browser, the time format changes to 'MM/dd/yyyy h:mm tt',
which causes errors in the dashboard functionalities, particularly in those IronPython scripts that rely on the time format.

I would like to know how I can prevent this change in the DateTime format.

Thank you,

[David Boot-Olazabal]

Hi PBR,

You may try the solution in this article:

Within the code, you need to alter this line of code

if column.Properties.DataType.ToString() == 'Date'

It should be:
 

if column.Properties.DataType.ToString() == 'DateTime” 

Then you can set your preferred format, eg dd/mm/yyyy hh:mm

Kind regards,

David

[David Boot-Olazabal]

Also, there is an existing enhancement request for this: https://ideas.spotfire.com/ideas/SPF-I-714

You may want to vote for that idea as well.

Kind regards,

David

[Andreas]

Hi, 

I think this problem should be done, if you use a Custom Format String in  "Column Properties" or any "Format" option for your datetime column.

In this case client and web will have the same format of a date time. 

 

 

[PBR]

Thank you very much David and Andreas,

The custom formatting fixed the issue.