Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date field in SQL
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00124579
Message ID:
00124616
Views:
25
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
Map
View

Click here to load this message in the networking platform