Date conversion

  • Thread starter Thread starter PJFry
  • Start date Start date
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!
 
Take a look at the Format() function.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top