cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud-Date format issue at model level

09-12-2022 9:36 AM
govardhanarao Explorer
1495 views 2 comments
0 Likes
SAP Managed Tags
Subscribe

Hello ,

Can Anyone please help me.

I wanted to change the date format DDMMYY to DD-MM-YY at model level but unable to do it? How we can change format ?I tried with date format but no luck.

Best Regards,

Govardhana

0 Likes

Accepted Solutions (0)

Answers (2)

Answers (2)

N1kh1l
Active Contributor

govardhanarao

The following dateformats are supported: dd-mm-yy, dd.mm.yy, dd/mm/yy, dd-mm-yyyy, dd.mm.yyyy, dd/mm/yyyy, dd-mmm-yyyy, dd-mmmm-yyyy, mm-dd-yy, mm.dd.yy, mm/dd/yy, mm-dd-yyyy, mm.dd.yyyy, mm/dd/yyyy, mm.yyyy, mmm yyyy, yy-mm-dd, yy.mm.dd, yy/mm/dd, yyyq, yyyy, yyyymm, yyyy-mm, yyyy.mm, yyyy/mm, yyyymmdd, yyyy-mm-dd, yyyy-mm/dd, yyyy.mm.dd, yyyy/mm-dd, yyyy/mm/dd, yyyy.mmm, yyyyqq.

But the format of date is done during model creation/rebuild itself by selecting the date column and selecting the format.

For model rebuild click on the below icon

Please upvote and accept if it helps.

Nikhil

avsalynin
Active Contributor
0 Likes

govardhanarao

You can do this in the model editing mode: select the column with the date and in the settings on the right there is an option date format