Opening a specific date range from SQL tablesI open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days.
Here is my open table script:
Open Database(
"DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
"SELECT * FROM dbo.VisitLog", "VisitLog"
);
The column I want to reference is VisitStart which is a datetime column. I want to essentially be able to say I want to open all data > Today() - in days(7)
Please help!
Data AccessRe: Opening a specific date range from SQL tablesThis is a SQL question -- and it depends on they type of database you're querying.
You might try
SELECT * FROM dbo.VisitLog WHERE CreateDate > SYSDATE - 7
If it is an Oracle database then this should work.
