custom expression Today() minus seven days in query builder
Attempting to obtain all releases by date (reldate) 7 days ago from ORACLE through ODBC Connection table.Code below returns the attached error image: SELECT DISTINCT t1.PIN, t1.PCP, t1.LASTNAME, t1.COMDATE,
t1.RELDATE, t1.JLOCAT, t1.SEX, t1.RELTYPE,
t1.RELAUTH, t1.RELCUST
FROM schema.table t1
WHERE ( ( ( t1.RELDATE >= (Today() - In Days( 7 )) ) 2nd question:Once I get this query straight, does ...