Find Max_Date and Min_Date

[raviprakashg]

this My Query"Select StartDt,EndDt from Table1"Now i will get an Recordset with collection of StartDate and EndDate, What i want is form the recordset i want to get the MaxDate and MinDate from one of these field"i use ASP, MsAccess"i think u Understand my Problem, Help me pleaseUr Dear Ravi

[Kcarson]

this My Query"Select StartDt,EndDt from Table1"Now i will get an Recordset with collection of StartDate and EndDate, What i want  is form the recordset i want to get the MaxDate and MinDate from one of these field"i use ASP, MsAccess"i think u Understand my Problem, Help me pleaseUr Dear Ravi

<{POST_SNAPBACK}>

You should be able to use the max/min functions. You would do it something like this:

SELECT MAX(StartDt), MIN(EndDt)FROM Table1

[pulpfiction]

Hi Ravi,Well if you want to do it in ASP, it is definitly tedious, one option is to sort the dates and take the first and last value.HTH

[aspnetguy]

The best, most efficient, and easiest, way to do it is with the sql query...the one already provided should work. If you do it as the scripting level it will be more owrk for you and will take more processing power.