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?

[petedonald]

The date format displayed for in Analysis for Office is dependent on the user prefernences in SAP Client.

To change this log into SAP Client: More>System>User Profile> User Data
Go to Defaults tab and change the Date Format

This worked for me and I was able to change from dd.mm.yyyy to mm/dd/yyyy