Hi there, I have a query that I want to modify so I can get the soonest date from a few different records
Set TicketDiscount=oConn.Execute("SELECT * FROM ticket_discount WHERE ticket_ID="&Request.QueryString("ticket"))
The records have dates of expiry, eg
ticket 1 exp=2/12/16
ticket 2 exp=8/5/1=7
What I want to do is grab the ticket that the expiry is soonest, how would I modify my query to do that?