INVERTED DATE FORMAT

[hpwinkelmann]

Hello,

I'm trying to use QlikView to create reports from SAP.

Generally this is working without bigger problems, but one SAP table is not easy to use.

In SAP table TCURR the field GDATU is in inverted date format. This means in the table I find the value 79889874 for the 2011-01-25.

Does anybody know how to convert this inverted date into a normal date? Is QlikView having a function for this?

Thanks and regards

[#2]

Hans-Peter,

For the GDATU field in TCURR I used the following to convert.

Which gives you the results :

Best regards,

Ken