Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Min Function

Status
Not open for further replies.

jconway

Programmer
Dec 14, 2005
50
I have a query and I'm using a subquery to create a new field with a date. The problem I'm running into is I'm trying to get the date 2 dates after the date field I have, so I'm more or less looking for the 2nd minimum date. Any ideas on what function to use to do this?

Thanks in advance!
 
What do you mean by date to dates? Give an example of the data you are working with, and what you mean by a min date.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top