Sorting Records by Date
I have created a real estate sales database and I would like to sort these sales by the date they sold. However, when I sort by ascending date I get 11/21/2007 before 2/1/2006. I see what is happening but I don't know how to correct it. Please advise.
By the way, if not obvious by the nature of my question, I am very knew to FMP and to MAC as well.