> good day
>
> please help realy need your help
> i have a condition date from and date to and what i want to happen is
>
> date from not greater than 24.00 military time and date from not greater than or equal to date to
> i used date picker calendar
>
> please help
>
> thanks
>
>
> **** VALIDATION
> SELECT * FROM tblaccess WHERE between(ldfrom,datefr,dateto) OR BETWEEN(ldto,datefr,dateto) INTO CURSOR curValidDate
> SELECT curValidDate
> BROWSE TIMEOUT 0.01
> SELECT * FROM curValidDate WHERE (terminal = lcterminalname OR usercode = lcusercode) AND isaccess = .t. INTO CURSOR curTV1
> SELECT curTV1
> BROWSE TIMEOUT 0.01
> SELECT * FROM curTV1 WHERE usercode = lcusercode AND between(ldfrom,datefr,dateto) OR BETWEEN(ldto,datefr,dateto) INTO CURSOR curTV READWRITE
> SELECT curTV
> BROWSE TIMEOUT 0.01
> GO TOP
> SCAN
>
Hi,
what are the values of :
ldfrom, ldto, tblaccess,datefr, tblaccess.dateto
and what are the vartypes of these?
regards,
Koen