Skip to Content

TIMESTAMP fields formatted incorrectly in Analysis for Office

Apr 07 at 03:43 PM


avatar image

Hi Folks,

I am consuming a HANA Calculation View through Analysis for Office.

One of my fields has the type TIMESTAMP.

When displaying data in HANA Studio, everything appears fine.

However, when displaying data in Analysis for Office, the timestamp values look to be formatted incorrectly.

Has anybody come across this before? And does anybody know a good fix, to ensure the front end presents this information correctly?

Kind Regards,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Apr 07 at 03:47 PM

Hello Elliott - if you are using Analysis Office 2.6 please consider reviewing the option "Excel Native Rendering of Date and Time" mentioned in this blog:

Good luck

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

Thanks for your suggestion. Unfortunately, native rendering didn't seem to help either - it changes the format to something which is still wrong, just in a different way :-)

still-no.jpg (33.0 kB)