> >
> > Maybe you mean InputMask to "99:99" :)
> >
> > OK, but in this case the 2nd textbox (say variable X) is string, so bad for validating. Better will be a decimal number like "99.99" where I can validate
> >
RETURN BETWEEN(INT(X),0,23) AND BETWEEN(MOD(X,1),0,59)
> >
> > Petr
> >
Punk and Foxpro is not dead>
> No, you will find that the input mask of 99:99 is insufficient. The minutes need to be one greater. "99:999" Read InputMask help.
>
> Validate with
>
BETWEEN(left(x,2),"00","23") and BETWEEN(right(x,2),"00","59")
>
> Tony
Maybe you mean this ;-)
The colon or W letter is simply ignored in input. Finally I decided to save the time of day as decimal number with 2 decimal places. For users will be simple to use numeric keyboard for writing.
Petr
Punk and Foxpro is not dead