Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with External Data Queries
ok this is what I'm typing for my value in the query
=#2005/10/25 7:00:00 AM# And <=#2005/10/26 8:00:00 AM# This is what Access changes it to automaticlly =#2005/10/25 7:00:00 AM# And <=#2005/10/26 8:00:00 AM# This was a code I got from a helping hand. Between [Enter a start date] And [Enter an end date] The plan is to have the [Enter a start date] referance a cell, same goes for the [end date]. Presently I have cells B1 and B2 with the start and end date. But no matter which way I try to enter in the dates I keep getting errors on matches to format string or an error about invalid month. I've checked my Date formats everywhere I can think of and have changed them all to yyyy-mm-dd hh:mm:ss AM/PM. Any help would be most kind. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Inport External Data - new queries | Excel Worksheet Functions | |||
Excel 2002 External Data Queries and UNC !HELP! | Excel Discussion (Misc queries) | |||
Edit Get External Data Queries | Excel Programming | |||
External Data Queries and Cookies | Excel Programming | |||
External data queries within applcation collection | Excel Programming |