validating hour

[fishman13]

I have a form that has a control box used to store a time. The box is set with an input mask of 99:99. Is there a way to determine if a valid time is entered or do I need to convert the field to a date time. I was currently trying to use val(this.value), but only the hours are being checked.

 

[torturedmind]

i haven't tested this but you may want to try. in the control's valid event, put the ffg. code:

local okhr, okmin

okhr = iif(between(val(left(this.value,2)), 0,23), .t., .f.)
okmin = iif(between(val(right(this.value,2)), 0,59), .t., .f.)

if okhr and okmin
     [do valid]
else
     [do invalid]
endif

kilroy
philippines
"and that's what we call creativity..."

 

[andreateh]

this maybe help :

In the Valid Procedure of the textbox

if empty(ctot(this.value))
  return .F.
endif

If u enter an valid time, i mean Hour 0~23,min 0~59,sec~059. It will return a valid datetime else CTOT(this.value) will return nothing. Where this.value is Character.

?ctot("23:59:59") &&(valid time)
?ctot("24") &&(invalid hour,empty)
?ctot("23:60") &&(invalid hour,empty)