General information
Category:
Forms & Form designer
Jane,
You might give ". . . DTOC(cash.postdt) >= . . .".
Good luck,
Jim N
>>Thanks for the reply.
>> The SQL statement is
>> SELECT cash.source, cash.dept, cash.amt from cash INTO CURSOR tempcash WHERE TRIM(UPPER(cash.source)) = thisform.txtsource.value .AND. cash.postdt >= thisform.msdt.value
>>
>>and yes, postdt is a date field
>>
>>Thanks
>
>Are any of the values .null.? This could be causing you problems.
>
>Wayne
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only