date format in YYYYMMDD

[pikachu]

If the date format in my data is YYYYMMDD, how do I inform Report Studio that the data is in date format so that I can use the "Data Format" to specify how to display the date?

Also, how do I choose to automatically roll-up the dates in a crosstab? thanks for any help.

[mrcool]

Use to_date function to convert 2 date formate

[pikachu]

sorry if this sounds like a dumb question, should I do this in FM or in Report Studio? which is better?

[mrcool]

Do in reports,.....