cancel
Showing results for 
Search instead for 
Did you mean: 

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

tilted
Explorer
0 Kudos

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.

tilted_0-1716825169699.png
BR

 

View Entire Topic
rrajmahesh09
Explorer
0 Kudos

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
Active Contributor

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. 

Date_Hier_Description.png

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
Explorer
0 Kudos

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?

tilted_0-1717155027812.png

BR