SAP Analytics Cloud-Date format issue at model level

[govardhanarao]

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

[N1kh1l]

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]

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