Date shown wrong in SAP Analytics Cloud based on SAP...

[#1]

Hello, 

i have the issue that the date is displayed as YYYY-MM-DD. 

How can I change the display in DD-MM-YYYY in Datasphere?
The field voucher_date is already recognized as date field but the correct format does not work. 

The default date formatting in SAC is already configured in DD-MM-YYYY.

BR

[MKreitlein · Accepted solution]

Hello @tilted 

this is a well-known missing feature (for German Datasphere users) that SAP does not provide an in-built function to display a German date format 😪

What you see here is the internal key for the dates, like stored on the database.

We (German users) have to create our own date format in an additional (text) view... which you associate to your date field... then in the SAC story you can display the text as dd.mm.yyyy, and the key is still the internal format.

Formula: CONCAT(Tag,CONCAT('.',CONCAT(MONTH,CONCAT('.',YEAR))))

BR, Martin