Date conversion

[PJFry]

I have a date in a mm/dd/yyyy format and I want to convert it to a yyyy/mm
format that I can sort. I tried doing Year([Order Date]) & "/" &
Month([Order Date]), but that converts it to text. I am ok with leaving out
the / and using . if that would make it work better.

Thoughts?
Thanks!

 

[PJFry]

Found it.

CDate(Year([Order Date]) & "/" & Month([Order Date]))

 

[Jeff Boyce]

Take a look at the Format() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP