Date format in a DataGrid

[KathleenBrenkert]

Is there an example anywhere of how to format a date field for a datagrid? I've  tried calling a labelFunction but  anytime I apply a dateformatter using code I get nothing returned.  I've tried a few variations of the code below.

public function getDateLabel(item:Object,column:DataGridColumn):String 
{
return dateFormat.format(item[column.dataField]);
} 

[RobertScheitlin__GISP]

Kathleen,

   Here is my date label function:

private function getDateLbl(item:Object,column:DataGridColumn):String
   {
    var dateMS:Number = Number(item[column.dataField]);
    var retVal:String = "";
    var rVal:String = item[column.dataField];
    if(rVal == null)
    {
     //do nothing
    }else{
     if (!isNaN(dateMS))
     {
      retVal = msToDate(dateMS, _dateFormat);
     }
    }
    return retVal;
   }

[KathleenBrenkert]

is the msToDate a function you have written? I get an error on that line.  I'm guessing it's a millisecond to date function?

[RobertScheitlin__GISP]

Kathleen,

   Yep, I did forget to include that 😮

   private function msToDate(ms:Number, dateFormat:String):String
   {
    var date:Date = new Date(ms);
    if (date.milliseconds == 999) // workaround for REST bug
    {
     date.milliseconds++;
    }
    
    if (dateFormat)
    {
     dateFormatter.formatString = dateFormat;
     var result:String = dateFormatter.format(date);
     if (result)
     {
      return result;
     }
     else
     {
      return dateFormatter.error;
     }
    }
    else
    {
     return date.toLocaleString();
    }
   }

[KathleenBrenkert]

Thanks Robert it's just what I needed.  The only problem I have now is it's not catching the rest date bug and all my dates are coming up as 1 day early.  Can you tell what I've done wrong with my msToDate code?

private function msToDate(ms:Number, dateFormat:String):String
   {
    var date:Date= new Date(ms);
    if (date.milliseconds==999)
    {
     date.milliseconds++;
     
    }
    if (dateFormat)
    {
     var result:String=mydateFormat.format(date);
     if (result)
     {
      return result;
     }
     else
     {
      return dateFormat;
     }
    }
    else
    {
     return date.toLocaleString();
    }
   }

[RobertScheitlin__GISP]

Kathleen,

   Are you running ArcGIS Server SP1?

[KathleenBrenkert]

I installed the service pack this morning but I still have the date problem.

[KathleenBrenkert]

I changed the code to read:

date.milliseconds=date.milliseconds + 86400000; \\adds a day

I also took out the if statement to force it to add a day every time.  I'm not too happy with this fix, but it's been the only thing to get my dates to actually show up correctly in this application.  Every other web app I have programmed I add a millisecond and its works fine.