convertion of dates

[shree909]

Hi ,

I have the date format as YYYYMMDD and i want to convert into MM/DD/YYYY

these are the dates i have

20130329

20130401

20130402

20130403

20130404

how to change the format..

[#2 · Accepted solution]

use functions date and date#:
date( date#( Field_with_Date, 'YYYYMMDD')) ,'MM/DD/YYYY')