Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator 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
Master
Master

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

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
Champion
Champion

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
Creator II
Creator II

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
Creator II
Creator II

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

Creator II
Creator II

No sorry, I never got it working.

Joerg

Highlighted
Partner
Partner

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