Discussion Board for collaboration related to QlikView App Development.
How can I get only time from below field?
I just want 11:35 or 12:25 etcI used Time# and other functions but doesn't work.. maybe because this string has YYYY-MM-DD HH:MM:SS and then some 000000...Those 0000's in the end doesn't give me correct time. I just get time as 00:00.
I think, your field in string format, try like below
=mid('2020-10-12 11:35:00.0000', 12, 5)
Mid(urtimestampfield, 12, 5)
View solution in original post
Thanks MayiMid(urtimestampfield, 12, 5) << worked