Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I get only time from below field?
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.
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)
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 Mayi
Mid(urtimestampfield, 12, 5) << worked