Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
omyahamburg
Contributor II

How to convert this timestamp

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

7 Replies
Highlighted
jsn
Honored Contributor

Re: How to convert this timestamp

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to convert this timestamp

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
datanibbler
Esteemed Contributor

Re: How to convert this timestamp

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

Highlighted
omyahamburg
Contributor II

Re: How to convert this timestamp

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.

Highlighted
fheidenstecker
Contributor II

Re: How to convert this timestamp

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

Highlighted
omyahamburg
Contributor II

Re: How to convert this timestamp

No sorry, I never got it working.

Joerg

Highlighted
Partner
Partner

Re: How to convert this timestamp

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