topic Re: Hexadecimal values to convert to date values in QlikView https://community.qlik.com/t5/QlikView/Hexadecimal-values-to-convert-to-date-values/m-p/404109#M150332 <HTML><HEAD></HEAD><BODY><P>try this</P><P>=num(num#('E0','(HEX)'))</P></BODY></HTML> Mon, 04 Mar 2013 13:31:52 GMT 2013-03-04T13:31:52Z Hexadecimal values to convert to date values https://community.qlik.com/t5/QlikView/Hexadecimal-values-to-convert-to-date-values/m-p/404108#M150331 <HTML><HEAD></HEAD><BODY><P>Hello I'm reading the pgo.xml files generated by QlikView server</P><P>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</P><P>one of the values is 40E42EECDA12F685</P><P></P><P>how can I convert this hexadecimal value to a readable date value</P><P>knowing that using the num or Date functions returns invalid values</P><P></P><P>Please advise</P></BODY></HTML> Mon, 04 Mar 2013 13:26:52 GMT https://community.qlik.com/t5/QlikView/Hexadecimal-values-to-convert-to-date-values/m-p/404108#M150331 ali_hijazi 2013-03-04T13:26:52Z Re: Hexadecimal values to convert to date values https://community.qlik.com/t5/QlikView/Hexadecimal-values-to-convert-to-date-values/m-p/404109#M150332 <HTML><HEAD></HEAD><BODY><P>try this</P><P>=num(num#('E0','(HEX)'))</P></BODY></HTML> Mon, 04 Mar 2013 13:31:52 GMT https://community.qlik.com/t5/QlikView/Hexadecimal-values-to-convert-to-date-values/m-p/404109#M150332 2013-03-04T13:31:52Z