How to convert this timestamp

[omyahamburg]

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

[Anonymous]

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

[kaushiknsolanki]

Hi,

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

Regards,

Kaushik Solanki

[datanibbler]

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

[omyahamburg]

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.

[fheidenstecker]

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

[omyahamburg]

No sorry, I never got it working.

Joerg

[anderseriksson]

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