Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

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

Try something like:

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

View solution in original post

2 Replies

Try something like:

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

View solution in original post

Contributor
Contributor

That worked great, thanks Bill!