Posted to microsoft.public.excel.programming

Chris Perry Chris Perry is offline

external usenet poster

Posts: 2

MS Query Date

When quering a table created in excel, I can create
criteria using the a date column and enter a specific date
(i.e. < 9/20/03) and the query works. It does not work if
I make the criteria prompt me for the date (i.e. <[Enter
Date]). I get the following error message in MS Query:
Invalid character value for cast specification (null).

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
date query	Hilton	Excel Discussion (Misc queries)	2	November 20th 07 10:42 AM
Date query	Crimson King	Excel Worksheet Functions	4	October 24th 07 01:54 AM
Date Query	Treza Blu	Excel Discussion (Misc queries)	4	May 31st 07 09:11 PM
Date query?	Harley	Excel Discussion (Misc queries)	2	May 11th 06 11:31 AM
How do I enter a date range ie -7 from current date in MS QUERY	notsmartenough	Excel Discussion (Misc queries)	1	November 11th 05 10:17 PM

All times are GMT +1. The time now is 04:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us