Sort Dates by Month

[Bill6868]

I have a date field that lists all our volunteer’s birthdays. I need to sort/list them by month and exclude the day and year. I’m looking to get a list of all January birthdays, February birthdays…and so on. The format in this field is 01/08/1930. If I create an expression to extract just the first two characters I.e. Left([Field1],2) I will get “1/” as it excludes the zero.

Would anyone have any suggestions?

Bill6868

 

[Andrzejek]

[tt]MsgBox Month(CDate("12/12/2012"))[/tt]

Have fun.

---- Andy

 

[dhookom]

If the field is a date/time data type then use [tt]Month([YourFieldNameHere])[/tt] to get the month number.

Duane
Hook'D on Access
MS Access MVP

 

[Bill6868]

Thanks Andy and Duane. The query expression Month ([YourFieldNameHere]) gave me the months in a number (1 through 12). From there I was able to proceed.

Much appreciated!

Bill6868