>> PADR(DTOS(s_Date) + PADL(ALLTRIM(STR(Schedule.s_HH * 100)), 2, '0') + ; >> PADL(ALLTRIM(STR(Schedule.s_MM)), 2, '0'), 30, ' ') AS Temp ; >>>>
padr(dtos(s_date)+transform(schedule.s_hh, "@L 99")+transform(schedule.s_mm, "@L 99"),30)I don't understand why were you multiplying hours with 100. Str(900) would be " 900", then allt() would give "900" and eventually padl("900",2,"0") gives "90". I simply prefer transform() with "@L" in the function part - old habit from 2.0.