Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MK9885
Master II
Master II

Get only time from a Data Time string

Hi,

How can I get only time from below field?

2020-12-08_131657.jpg

I just want 11:35 or 12:25 etc
I 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.

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

Hi @MK9885 

I think, your field in string format, try like below

=mid('2020-10-12 11:35:00.0000', 12, 5)

Mid(urtimestampfield, 12, 5) 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
PriyankaShivhare
Creator II
Creator II

Time(Frac(DateTimeField),'hh:mm')
MayilVahanan

Hi @MK9885 

I think, your field in string format, try like below

=mid('2020-10-12 11:35:00.0000', 12, 5)

Mid(urtimestampfield, 12, 5) 

Thanks & Regards,
Mayil Vahanan R

View solution in original post

MK9885
Master II
Master II
Author

Thanks Mayi
Mid(urtimestampfield, 12, 5)  << worked