AnsweredAssumed Answered

entering time

Question asked by TraceyAkin on Jul 22, 2011
Latest reply on Jul 26, 2011 by TraceyAkin

Title

entering time

Post

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)

Let (

[

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?

Outcomes