Off the top of my head...

In the ORDER BY clause, immediately before the 'MyDate' column, add this CASE statement:

CASE WHEN MyDate IS NOT NULL THEN 1 ELSE 2 END

That will cause the non-null entries to be returned first, followed by the null entries.