Hexadecimal values to convert to date values

[ali_hijazi]

Hello I'm reading the pgo.xml files generated by QlikView server

One of the xml tags is LastUsed which is the last date used by the user for a specified document CAL however this tag has a value which seems hexadecimal

one of the values is 40E42EECDA12F685

how can I convert this hexadecimal value to a readable date value

knowing that using the num or Date functions returns invalid values

Please advise

[#2]

try this

=num(num#('E0','(HEX)'))