Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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