Date conversion

P

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!
 
J

Jeff Boyce

Take a look at the Format() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top