Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

Hexadecimal values to convert to date values

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

I can walk on water when it freezes
1 Reply
Not applicable

try this

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