topic Re: How to convert this timestamp in QlikView

How to convert this timestamp

omyahamburg — Tue, 16 Apr 2013 05:34:43 GMT

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

Re: How to convert this timestamp

Anonymous — Tue, 16 Apr 2013 06:06:40 GMT

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

Re: How to convert this timestamp

kaushiknsolanki — Tue, 16 Apr 2013 06:24:43 GMT

Hi,

Could you please tell us which format is this. Meaning what date format?

Regards,

Kaushik Solanki

Re: How to convert this timestamp

datanibbler — Tue, 16 Apr 2013 09:39:05 GMT

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

Re: How to convert this timestamp

omyahamburg — Tue, 16 Apr 2013 11:50:03 GMT

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.

Re: How to convert this timestamp

fheidenstecker — Fri, 09 Dec 2016 14:32:23 GMT

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

Re: How to convert this timestamp

omyahamburg — Mon, 12 Dec 2016 06:12:49 GMT

No sorry, I never got it working.

Joerg

Re: How to convert this timestamp

Anders_Eriksson — Fri, 14 Feb 2020 13:27:05 GMT

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).