MDN date format in VI

[Hagay]

Hello,

In Visual Investigator on Viya 4 (maybe in other tools too) dates are formatted according to the MDN suggestions.

For the he_IL locale the MDN formatting is d.m.yyyy which is wrong. The correct formatting should be dd/mm/yyyy - days and months with leading zeros and slash as the separator.

My request is to override the MDN date format for the he_IL locale and use the correct format.

Thanks

[susantrueman]

Thank you for submitting this product suggestion. The product team are reviewing this in partnership with our globalisation team and we will share further updates via this SAS Communities post. 

Thanks

Susan

[susantrueman]

Hello, 

Thank you for submitting this product suggestion and apologies for the delayed reply. We have been reviewing this request in partnership with our software gloablisation team and can now share an update. 

Most libraries, including MDN and SAS libraries, rely on the Unicode CLDR (Common Locale Database Repository) Project to provide locale based formats. CLDR uses the dot as the separator for Hebrew date formats. We also reviewed official websites from the Israeli government and note that web UI components use the dot while some (English text) documents include dates that use forward slashes as the separator. 

From our research we understand that either dots or slashes may be used as the date format separator. 

In order to be consistent with the software industry, we continue to use what CLDR provides. If you would like to provide that feedback direct to the Unicode Org please consider opening a ticket with the Unicode Org to request a change for Hebrew language/date formatting. 

Thanks

Susan