SAP Knowledge Base Article - Public

3600270 - Dictionary Export shows different date format than expected

Symptom

Even though I configured a specific date format (e.g. d/m/y) in Process Manager  for my date type custom attribute ( Setup -> Define notations/attributes -> Dictionary -> select dictionary category -> Add) , the dictionary export shows a different date format than expected. 

The date in the dictionary export is displayed in the following format: YYYY-MM-DDTHH:mm:ss.sssZ (standard ISO 8601 format). However, I expect my specific date format (e.g. d/m/y) to get displayed instead.

Resolution

This is a known limitation that has already been reported to our Product Managers. If you are affected by this limitation and want to be kept up to date about this feature request, please create a ticket in our Support Portal and reference this knowledge base article.

As a workaround, you can use an excel formula to manually change the date. For example, if you'd like to change the standard ISO 8601 format to dd/mm/yy format, then you can use the following formula: =TEXT(DATEVALUE(LEFT(<UTC date cell>,10))+1, "dd/mm/yy")

Keywords

dictionary export, date,  date format, ISO, ISO format, dictionary, dictionary category, custom attribute, excel, UTC, soe , KBA , BPI-SIG-PM-DIC , Dictionary for SAP Signavio Process Manager , Product Enhancement

Product

SAP Signavio Process Manager all versions