AM/PM not showing up when using some culture settings

AM/PM not showing up when using some culture settings

book

Article ID: KB0076576

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions
Spotfire Server All Versions

Description

When choosing a time formatting for a column that includes AM/PM, this may not show up on some systems that do not have the AM/PM symbol defined. By default, some culture settings that do not AM/PM will have an empty value for the AM/PM symbol.

Issue/Introduction

When choosing a time format that includes AM/PM, this may not show up on some systems that do not have the AM/PM defined.

Resolution

To set the AM/PM symbol you can either use the control panel regional setting. Depending on your version of Windows, this may be in slightly different locations.Normally you reach it through "Change date,time, or number formats" and then "Additional settings" and the "Time" tab.

AM PM region setting in control panel

You can also set this by using the following registry keys in HKEY_CURRENT_USER\Control Panel\International and set them to the desired symbol :

User-added image