custom expression Today() minus seven days in query builder

jumboshrimps — Mon, 09 Apr 2018 14:33:52 GMT

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 JMP have an automated macro function to run this jmpquery every Monday morning at 3:00 am? - I also have the JMP addon for Excel 2010.

Re: custom expression Today() minus seven days in query builder

pmroz — Mon, 09 Apr 2018 14:52:23 GMT

You're missing two close parentheses.

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

If you have Oracle errors try executing the query in a SQL tool like PL/SQL Developer, Toad etc.

topic Re: custom expression Today() minus seven days in query builder in Discussions

custom expression Today() minus seven days in query builder

Re: custom expression Today() minus seven days in query builder