Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joe_mccorkel
Not applicable

Converting time out of a date stamp

Hello- I am tryilng to convert the time section of a date stamp that looks like '20180129060000' to be 6:00:00AM, or '20180129235900' to be 23:59:00/ 11:59PM. Ive tried using date(rignt('date',6)) and date(date#(right('date',6))). the first returns 12:00:00AM every time, and the second returns null. Any thoughts?

Thanks!

1 Solution

Accepted Solutions
bill_markham
Not applicable

Re: Converting time out of a date stamp

Try something like:

     ==time(time#(right(20180129235900,6),'hhmmss'),'h:mm:ss TT')

2 Replies
bill_markham
Not applicable

Re: Converting time out of a date stamp

Try something like:

     ==time(time#(right(20180129235900,6),'hhmmss'),'h:mm:ss TT')

joe_mccorkel
Not applicable

Re: Converting time out of a date stamp

That worked great, thanks Bill!