Can we change the date format in Analysis tool

[Former Member]

Hi ,

Presetly we are using HANA as database to build reports in Analysis . The View has the dat format displayed as "MM.DD.YYYY" but in Analysis it shows up as DD.MM.YYYY.Is there a possibility to change the DATE format in Analysis accordingly for different countries?

[Former Member · Accepted solution]

Hello Hema,

As far i know AA doesn't have the settings with respect to DATE format but an indirect way is to go for Calculation option or put a formula in Excel to convert into desired format.

Regards

Ganesh