I have a field called Time which is a numerical field. If the time is 13:45:52 then the value will be 134552. However, if the time is 00:03:24 then the value in the field is 324. I would like it to show 000324 so that I can then use the maketime function to convert it back into a real time format.
So how can I convert the number 324 into text '000324' in the load script? Or is there another way to convert 324 into a time?