Formatting string field to date format

building reports crystal reports
1

I am new to crystal reports XI and have a question on formatting fields. The field in question is date field defined as string on the database (20061205), When the field is displayed on the report is looks like yyyymmdd, I need to display the date in the format yyyy/mm/dd. I would appreciate some help in resolving this.
Thanks.

vfer :us: (BOB member since 2007-01-30)

2

If the date was stored in the database as a date you could use format masks in the toText function, but since it’s stored as a string the easiest thing to do is below.

stringvar x := {DATE_COLUMN};
mid(x,1,4) + "/" + mid(x,5,2) + "/" +  mid(x,7,2)

mke01 :us: (BOB member since 2006-08-22)