One last simple question (i hope)... How can I change a date from 1/1/2011 to say January 2011?
One last simple question (i hope)... How can I change a date from 1/1/2011 to say January 2011?
try this
Monthname(month(datefield)) & " " & datepart("yyyy", datefield)
Thank yo uso much for all your help.. you have been a lifesaver..