Yet Another Crosstab Date Nightmare!!

[CJBIRKIN]

Hello

I'm trying to sort the columns on a crosstab query by date where the date is grouped using a function such as

format([apptdate],"mmmm/yyyy")

I've looked in the other posts and the suggestions seem to say more or less the same thing i.e try yyyy/mmmm etc. The problem is no matter which way round i try it or whether i use format,datepart or month() & year() functions the damn thing seems to think the dates are strings so i either get

APRIL, AUGUST, DECEMBER etc

or

01/2002 ,10/2002 ,11/2002 ,12/2002,02/2002

or

2002/01, 2002/10 you get the idea!

any suggestions please!

Chris

 

[CJBIRKIN]

Hello

You did it again!!. Thanks thats saved the hairline for another day.

Cheers

Chris