How to remove Year from the Date field ?

[former_member563870]

Hi EveryOne,

In SAC, I have a field called "Operation Date" Where the live connection is loading the date and the date is displaying in below format.

Display : "15-03-2019 (2019)"

The year is repeating twice in the same field. How to remove the repeated year value from the field. I have tried all the SAC date format but it doesn't work.

Thanks In Advance

Regards

Jana

[TammyPowlas]

Hello Jana - I have removed your email from the message as this is against the SAP Community's rules of engagement. If you wish to be emailed, please make your email public on your profile.

[amitrathi239]

You can achieve this through creating calculating dimension object.

See below input column and output column.

My Final Calculated variable

[d/Date_qs:Date_1e312305a1].[p/DAY]+"."+SUBSTRING([d/Date_qs:Date_1e312305a1].[p/CALMONTH],5,2)+"."+[d/Date_qs:Date_1e312305a1].[p/YEAR]