>>Hi,
>>
>>I wonder what I am doing wrong in this case. Here is the SQL Select (simplified):
>>
>>*-- The fields in SQL Server table:
>>*-- PurchDate - Datetime
>>*-- Years - Integer (from 1 to 100)
>>dToday = date()
>>cWhereExpr = "'" + DTOS( cToday ) "' >= (PurchDate + Years) "
>>select * from MyTable where cWhereExpr
>>
>
>If nothing else, you're missing a + when building cWhereExpr. I'd expect that line to fail.
>
>Tamar
It was just a typo in my UT post.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham