Hello,
I have a time field that is formatted like 0734, i'm trying to format it as 07:34 with the statement below:
SUBSTRING(ResultTime,1,2) + ':' + SUBSTRING(ResultTime,3,2) AS Result_time
But, it's not working? What am i doing wrong? Any suggestions?