The following JavaScript method is used to format the date. formatDate('{@Inspections:DateAssigned}','yyyy/mm/dd') function formatDate(sDate,sFormat,lang){ var sYear = sDate.substring(0,4); var sMonth = sDate.substring(4,6); var sDay = sDate.substring(6,8); if (((sYear<1900)||(sYear>2050))||((sMonth<1)||(sMonth>12))||((sDay<1)||(sDay>31))) { strDate ='--'; } else { if (sFormat=='yyyy/mm/dd') { strDate = (sYear + '/' + sMonth + '/' + sDay); } else if (sFormat=='mm/dd/yyyy'){ strDate = (sMonth + '/' + sDay + '/' + sYear); } else if (sFormat=='dd/mm/yyyy'){ strDate = (sDay + '/' + sMonth + '/' + sYear); }else { if (lang=='English') var Month_Label = new Array('-','Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'); if (lang=='French') var Month_Label = new Array('-','Jan', 'Fév', 'Mar', 'Avr', 'Mai', 'Jun', 'Jul', 'Aoû', 'Sep', 'Oct', 'Nov', 'Déc'); else var Month_Label = new Array('-','Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'); strDate = sDay + '-' + eval('Month_Label['+sMonth+']') + '-' + sYear ; } } return (strDate); }