start grid view in selected row

I have a grid that has a date column and rows run a period of a year+. I would like to be able to show the grid at start-up sorted on the date column with the row 1 being the current date (or closest).

This might be done with an auto query that would only show rows with date col value of on or after the user computer date value. do not know how to do that.

anyone have experience with this?

thank you.