selecting start date-end date in database

[athos07]

I have this database, where i have a field called BIDdate that has format "mm/dd/yyyy". i have a record of 100 of dates.

How can i get the first date record and the last date record, using SQL and with out any input of date range.

 

[BlackKnight]

Hi,

If I understand you correctly, you want a query that can find the earliest date and the latest date in your table.

SELECT Min(table1.BIDdate) AS Startdate, Max(table1.BIDdate) AS Enddate
FROM table1;

Have a good one!
BK

 

[athos07]

BlackKnight

thank you very much it worked
both solution worked

i hope i can return the favor if your going to have ur problem

thank you again

athos