View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dkso Dkso is offline
external usenet poster
 
Posts: 8
Default Date or datetime

I connect to an Oracle DB in MS Excel query. The format of the datetime
field in the DB is:-
2003-07-16 20:03:32

I want to be able to produce a prompted query from Excel I understand that
the user can enter data into a cell and refresh the query, which will use
the entered data as it's criteria.
How do I do this?

I want the user to enter two DATES (not Date Time or possibly date and
00:00:00)as a between (Start and End dates).


--
Regards Dean

www.dkso.co.uk/
http://homepage.ntlworld.com/dkso