Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query logic concerning dates
Given a field in a database has dates
In this example lets assume the data base the following dates 1/18/2008 9/3/2008 12/30/2008 1/27/2009 I would like the ability to enter a date and have the query pull the right information explained below.... Any date starting with 1/18/2008 through 9/2/2008 would pull information from the first record. Likewise any date after 1/27/2009 will use the information from that record. That is until another record is added. Likewise any date before 1/18/2008 will not provide any information. Essentially the query performs a vlookup and selects the date closest (without exceeding) to the date inputted by the user and selects the information from that particular record? Can this be done without inputting those key dates in a spreadsheet or in the macro query? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates in SQL query won't match | Excel Programming | |||
How do I export dates into a query? | Excel Discussion (Misc queries) | |||
How do I use variable dates with a SQL Query | Excel Programming | |||
web query in VBA (format dates in url) | Excel Programming | |||
dates in query | Excel Worksheet Functions |