My Navision SQL database has a timestamp field giving me values like this:
Is it possible to convert them into a date/time format ?
Could you please tell us which format is this. Meaning what date format?
I had the same issue recently (though my timestamp did not contain alphanumeric characters). I think you need to adapt the display format in the object_properties of your object on the numbers tab.
Thank you all for care.
I found another topic: http://community.qlik.com/message/2121#2121
where Héctor Muñoz posted an app with a macro to convert from hex to decimal.
I think I only need a solution to delete all leading zeros out of my hex values.
Hi, did you ever get this to work?
I have the same Problem, some Hex based timestamps from NAV, i want to convert them into a readable format.
I can convert them from Hex to Decimal, but what do i have to do next?
IT's NOT a date, it's just an ever increasing number stamped on each row when created/updated.
You can track which rows you need in an incremental update (all that have higher timestamp than your previous read).