Hi,
I have a cross tab which has dates as the columns, i want these formatted as mmm-yy as the day is unimportant, I can get them formatted as such, but when the sorting is applied they are sorted alphabetically not in date order.
Is there a way round this? Having them show as dd-mm-yy will cause confusion when looking at is as people will think it's for specific date rather than the month.
The date is actually 01-mm-yyyy, always the 1st of the month from the table it comes from.
Any idea's?
Thanks
I have a cross tab which has dates as the columns, i want these formatted as mmm-yy as the day is unimportant, I can get them formatted as such, but when the sorting is applied they are sorted alphabetically not in date order.
Is there a way round this? Having them show as dd-mm-yy will cause confusion when looking at is as people will think it's for specific date rather than the month.
The date is actually 01-mm-yyyy, always the 1st of the month from the table it comes from.
Any idea's?
Thanks