>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
>

>
>Example: PurchDate is 2018-01-05 and Years is 10. But the record is included in the resulting query.
>Shouldn't the PurchDate + Years being much higher than the current date?
>
>UPDATE: I think my problem is that I have to convert Years into years since SQL Server sees it as Days. But how? Should I multiply the Years by 365? Or there is a better way to convert the int number into years?

So, the suggestion given by Borislav works very well (below) for SQL Server database)

dToday = date()
cWhereExpr = ['] + DTOS( cToday ) [' >=DATEADD(year, Years, PurchDate) ]
select * from MyTable where cWhereExpr

How would I change the above for VFP database? Does VFP have function similar to the SQL Server's DATEADD()?

TIA