How can i get min(value) and Max(value) for the particular modified date?

[jash]

How to Get a Min and Max column value for the Modified date

I want to select top and bottom column value for the particular date.

Table:

DATE MODIFIED DATE VALUE
03:02:2009 04:02:2009 100
03:02:2009 04:02:2009 200
03:02:2009 04:02:2009 400
04:02:2009 05:02:2009 150
04:02:2009 05:02:2009 200
04:02:2009 05:02:2009 500

In my Table - Date Column and Value column is there

How can i get min(value) and Max(value) for the particular modified date?

Modified date should be n number of date, suppose am giving from this modified date to this modifed date

I want output like this

MODIFIED DATE MIN VALUE MAX VALUE

04:02:2009 100 400
05:02:2009 150 500