SQL "Select" help needed
From: robert prater <praterrd_at_pg.com>
Date: Wed, 27 Jan 1999 14:58:40 -0500
Message-ID: <36AF6FF0.1BDA_at_pg.com>
[Quoted] I'm using SQL code in an excel macro to extract production data from Oracle.My select statement uses two variables recieved from the equipment operator by way of an InputBox.(begin and end dates) I want this macro to run automatically twice a day (6am and 6pm).It will execute the SQL code,but the operator will no longer put in begin and end times thru the input box (it's going to select statement). Is there a way for me to hard code times, but have date pickup today's date or yesterday's date and use it in select statement?
Date: Wed, 27 Jan 1999 14:58:40 -0500
Message-ID: <36AF6FF0.1BDA_at_pg.com>
[Quoted] I'm using SQL code in an excel macro to extract production data from Oracle.My select statement uses two variables recieved from the equipment operator by way of an InputBox.(begin and end dates) I want this macro to run automatically twice a day (6am and 6pm).It will execute the SQL code,but the operator will no longer put in begin and end times thru the input box (it's going to select statement). Is there a way for me to hard code times, but have date pickup today's date or yesterday's date and use it in select statement?
For example: shift 1 = (today's date) 6 am to (today's date) 6 pm
shift 2 = (yesterday's date) 6 pm to (today's date) 6 am
(Our plant went to 12 hr. shifts)
I shouldn't have any problems getting the macro started automatically,
just the "select" statement.
(just a newby) --Ziggy--
Received on Wed Jan 27 1999 - 20:58:40 CET