Sorting by Date

[tmoney101]

I want to run a sql query that returns records from a particular date range, say by month.

One of the fields is a date field type datetime.

anyway any help would be great.

thanks.

[Mittineague]

Maybe something like
SELECT whatever FROM table WHERE datefield > 'date' AND datefield < 'date' ORDER BY datefield (either ASC or DESC)