Figured something like that. :-)
>Carl write a pure TSQL commands, He (I think) supposed you use SQL Server and DateTime fields.
>
>>Carl
>>
>>Thanks for the input. Can't say I recognise the language you wryte the snippet in but it doesn't work as foxpro. ?
>>The dates are not DateTime vars and the the Between function used in your code is not the Between() fn. of vfp, and will not work outside an SQL expression.
>>
>>So all in all I'm a bit confused as to what you're demonstrating. :-|
>>
>>Cheers
>>
>>Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.