Something

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);
}