Extracting relevant info. from Date / timestamp in adobe flex with row object

Question

I have this code :

var dp:Array = new Array();

for ( var i:int = 0; i < e.result.length; i++ ) { var row:Object = e.result[i];

       dp.push( row  );

}

The row object consists data for different columns of a datagrid. dp.push(row) pushes the data onto the datagrid.

Columns with index 3 and 4 have type of "DATE" with whole time stamp being displayed. Is there any method in flex which will help me extract the monnth/day/year from date or timestamp for that matter.

If yes, How do I do it in code.

Please help.

Answer 1

The as3corelib library has a utility class to parse timestamp strings into Date instances. Look into using the DateUtil class, specifically one of the parse methods such as parseW3CDTF.

From the resulting Date instance, you can examine the individual date properties then.

var dt:Date = DateUtil.parseW3CDTF( timestamp );
trace( dt.year );

Answer 2

After re-reading your question, it sounds like you're looking to change the display of the date object in the datagrid itself? For that, you should look at using a labelFunction for the DataGridColumn that is displaying the Date instance.

<mx:DataGridColumn labelFunction="dateFormatLabelFunction" />

private function dateFormatLabelFunction( item:Object, column:DataGridColumn ):String 
{ 
    return item.date.day + "/" ; //...
}

Or, alternatively, use the DateFormatter to format the date in the label function:

<mx:DateFormatter id="dateFormatter" format="MM/DD/YYYY" />

private function dateFormatLabelFunction( item:Object, column:DataGridColumn ):String 
{ 
    return dateFormatter.format( item.date );
}

EDIT: Per comments, the combined approach code sample would look something like this:

<mx:Script>
    <![CDATA[
        private function dateFormatLabelFunction( item:Object, column:DataGridColumn ):String 
        { 
            return dateFormatter.format( item[ column.dataField ] );
        } 
    ]]>
</mx:Script>

<mx:DateFormatter id="dateFormatter" format="MM/DD/YYYY" />

<mx:DataGrid ...>
    <mx:columns>
        <mx:DataGridColumn dataField="myDateField" labelFunction="dateFormatLabelFunction" />
    </mx:columns>
</mx:DataGrid>

Answer 3

thanks that worked