How do I take a date 9/02/2005 and make it so I can group them by month, i.e 9/2005.
W wmfrost Sep 2, 2005 #1 How do I take a date 9/02/2005 and make it so I can group them by month, i.e 9/2005.
O Ofer Sep 2, 2005 #3 If you don't want the months of different years to group together then you can use Format(datefield,"mm/yyyy")
If you don't want the months of different years to group together then you can use Format(datefield,"mm/yyyy")
D Douglas J Steele Sep 2, 2005 #4 Or, depending on how you want them to sort, Format(datefield,"yyyy/mm")
