ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Oracle Date format (https://www.excelbanter.com/excel-programming/283907-oracle-date-format.html)

Dean[_4_]

Oracle Date format
 
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




All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com