Bob,
Thank you for your post.
Unfortunately, the problem I am having is that I have the following dates in a text field in my table
2009
2/1/2008
6/1997
and no date
Of course, when you sort on text fields I get the following result
no date
2009
2/1/2008
6/1997
Of course I want
no date...