I have a dynamic crosstab with dates as the column headings. The results of the crosstab go into an unbound report. This is all working well. The crosstab headings are appearing as the short date format, no matter what I do in either the crosstab or the end report, I can't get the long date format that I want. The format for the unbound fields in the report is set to long date but it's still 24/08/01 (UK!) that is showing.

Can anyone help?

Thanks

You'll probably have to use the Format function in the crosstab, the help file should give you the correct syntax I think it's Format(YourField,"Long Date")
HTH

Thanks Rich, perfect.

Dawn