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