Hi all

I have a field in my report that is a string which accepts dates from my database.

The data in the database is stored as a string in the format "20070817" , i wish to be able to format it in ways such as "Wednesday, November 12, 2007" for example.

Can any one tell me how to do this?
Thanks!