Hi, I am retrieving dates via a PHP script (mySQL), and using the drag'n'drop Data Connection and DataGrid components using Flash MX (though I now have the lastest Pro version!). The component interface allows you to set the data formats, including the date.
I need to be able to sort the date, which also shows time of day. I had hoped to present the date in the format:
Mon 27-06-2007, 2:34pm.
But having a real problem getting there. Would anyone have a moment to provide the details on how to do this? ;-) The date is stored in the database as a timestamp, and I can tweak the php script to provide the date in any format required.
It is not clear to me how to mix the drag'n'drop bits with actionscript (though I have had some success in setting fonts and colours via actionscript).
Many thanks in advance,