Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
My Navision SQL database has a timestamp field giving me values like this:
00000000024EE1A6
00000000024EE1A5
00000000024EE1A7
...
Is it possible to convert them into a date/time format ?
Thanks.
Joerg
Hi Joerg,
Here's a good thread explaining the timestamp in Navision:
http://www.mibuso.com/forum/viewtopic.php?f=33&t=51562&start=0
Hi,
Could you please tell us which format is this. Meaning what date format?
Regards,
Kaushik Solanki
Hi,
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.
HTH
Best regards,
DataNibbler
Thank you all for care.
num(num#(stamp,'(HEX)'))
probably works.
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?
Thanks,
Fabian
No sorry, I never got it working.
Joerg
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).