Posted to microsoft.public.excel.programming

Smorgan

external usenet poster

Posts: 1

How do I select on a SQL Datetime field in Excel Query?

I can't seem to find the correct format for the date so that it will actually
exclude or include certain dates.
I am trying to do a parameter query where I can then enter a date range of
the records I want this time.
This is a database query from a SQL table.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Query DateTime String	Dean	Excel Worksheet Functions	1	January 23rd 06 12:07 PM
How do I create a query field in Excel	Sean	Excel Discussion (Misc queries)	1	July 20th 05 08:47 PM
Removing characters from datetime field	Sujesh	Excel Discussion (Misc queries)	3	July 14th 05 03:22 PM
Using datetime fields as parameters in a query...	Olaf Stetzer	Excel Programming	1	January 7th 04 02:55 PM
datetime in query	Ling[_2_]	Excel Programming	1	August 8th 03 05:08 PM

All times are GMT +1. The time now is 01:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us