Hi, I need to enter time without entering ":" or ".".
For instance want to be able to enter "07010000" and have it show as "07:01:00.00"
In the past
My field was set up as TiME
Under Auto-Enter I checked calculated value and specified the calculation as
//If(Get(RecordNumber)=1;Self; GetNthRecord(Start time;Get(RecordNumber)-1)+30)
x = GetAsText( Self ) ;
h = GetAsNumber ( Left ( x ; 2 ) ) ;
m = GetAsNumber ( Middle ( x ; 3 ; 2 ) ) ;
s = GetAsNumber ( Right ( x ; 2 ) )
Time ( h ; m ; s )
I would then enter "070100" and it would show "07:01:00" I can't figure out what to add to the formula so that I can enter the MS too. Any suggestions on how to add the ".00" part to my time?