Date shown wrong in SAP Analytics Cloud based on SAP Datasphere data model

[#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

[rrajmahesh09]

Hello @tilted ,

Two things to perform:

1) You can change the data display settings in your user accounts, set this to dd-MM-YYYY. To change this >> User >> Settings >> Language & Region >> Date Formatting - change here

2) Create a calculated column Date1 with datatype string in the desired format e.g: TO_VARCHAR(DELIVERYDATE,'DD-MM-YYYY')

3) Create another calculated column Date2 with datatype Date, use the function CAST to convert back to date. e.g: CAST(Date1 AS DATE) - this time apply the conversion on the first calculated column.  

This helps to preseve the datatype format without a need for the text association.

Happy modeling, Cheers, Mahesh

[MKreitlein]

Hi rrajmahesh09.

Might be that your solution works as well (have not tested it), but my solution comes with the advantage that you keep the time hierarchy Year-Month-Day on the Date field, if you associated this. 

And you have only the one Date field in your model, you need.

One major disadvantage remains... in an input variable for the date, you still have to enter the internal format: YYYY-MM-DD

BR, Martin

[tilted]

Hello MKreitlein,

i also use the date sap-time hierachy like you and associate the date field with the day dimension.
But i don't get the full date in the descriptions (01.01.2023) just the day (1).
What should be adjusted in the analytical model?

BR