Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joe_mccorkel
Partner - Contributor
Partner - 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
Anonymous
Not applicable

Try something like:

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

View solution in original post

2 Replies
Anonymous
Not applicable

Try something like:

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

joe_mccorkel
Partner - Contributor
Partner - Contributor
Author

That worked great, thanks Bill!