How to get dates to sort in Chronological Order

[mskitty]

When it comes to dates, I need them to sort earliest to the latest and in the order that the calendar is, but instead when I sort them in Ascending order I get this:
2015/1
2015/10
2015/11
2015/12
2015/2
2015/3
2015/4
2015/5
2015/6
2015/7
2015/8
2015/9
2016/1
2016/2
2016/3
2016/4
2016/5
2016/6
2016/7
2016/8

What I need is 2015/11, 2015/12, and so on

 

[bob fitz]

Try:
SELECT CDate([YourField] & "/01") AS dat
FROM YourTable
ORDER BY CDate([YourField] & "/01");

 

[mskitty]

Thank you for your help.

 

[bob fitz]

Your welcome. Glad to be of help.

 

[Ranman256]

those are not dates.