>dPassDate = date() && but could be a different date since user can change it from the current date to a future date >IF plSqlServer > cLifeExpFilter = " AND (PURCHASED IS NOT NULL AND LIFE_EXP IS NOT NULL AND LIFE_EXP > 0 AND ('" + >DTOS(dPassDate) + "' >= DATEADD( year, LIFE_EXP, PURCHASED)) ) " >ELSE > *-- VFP DB > cLifeExpFilter = " AND (!EMPTY(PURCHASED) AND LIFE_EXP > 0 AND '" + DTOS(dPassDate) + "' >= >DTOS(GOMONTH(PURCHASED,LIFE_EXP*12)))" >ENDIF >Then it is better, you don't need to cast (actually did the casting to remove time portion). Looks like you are using ADO (if not easier to write for ODBC):
IF plSqlServer cLifeExpFilter = " AND (PURCHASED IS NOT NULL AND LIFE_EXP IS NOT NULL AND LIFE_EXP > 0 AND ( " +; " ? >= DATEADD( year, LIFE_EXP, PURCHASED)) ) " ELSE *-- VFP DB cLifeExpFilter = " AND (!EMPTY(PURCHASED) AND LIFE_EXP > 0 AND ? >= GOMONTH(PURCHASED,LIFE_EXP*12))" ENDIF dPassDate = date() && but could be a different date since user can change it from the current date to a future date * add m.dPassDate to parameters