Currently, I have a report that displays time in military format but it includes seconds like 145098. The field may be six digit long or five if is in the morning live 70202. The last two digits are always the seconds. I tried to turn this number field into a display format but it only works when I have six digits.
This is the formula: ( I am new at this!)
@display
WhilePrintingRecords;
stringVar tempTime := totext({PLINCD.INCALT},0)
@time
picture({@Display time},"xx:xx:xx"
of course it only works on six digits. I have tried other formulas but I haven't found a solution.
I like the time to show in military time but only HH:MM
Please help!
This is the formula: ( I am new at this!)
@display
WhilePrintingRecords;
stringVar tempTime := totext({PLINCD.INCALT},0)
@time
picture({@Display time},"xx:xx:xx"
of course it only works on six digits. I have tried other formulas but I haven't found a solution.
I like the time to show in military time but only HH:MM
Please help!