<div>
What about in MySQL? 
 
I've already tried using Date in Flex but I couldn't format the response from MySQL correctly to get it to display in the DateField. &nbsp;I also struggled to get the correct format to go back to the database. &nbsp;Have you sample code which can demonstrate this functionality? 
 

</div>

<div>
In mySQL use date time. &nbsp;I use Coldfusion not PHP so php might be doing a funny conversion as AMF send's dat over the wire as seconds from 1970. &nbsp;What are you getting back from Flex? &nbsp;
</div>

<div>
Well the select statement returns a string from the datetime field. &nbsp;I get this error when running Flex in debug mode 
 
TypeError: Error #1034: Type Coercion failed: cannot convert &quot;2009-01-01 00:00:00&quot; to Date.
</div>

<div>
I'm using Charles to view the values being passed between server and client and I can see that the values for 'start_date' are being passed as a string in the format mentioned above. 
 

</div>

<div>
in Flex do this 
 
var tstDate = new Date(&quot;2009-01-01 00:00:00&quot;); 
 
And look at tstsDate. 
 
If you are sending and receiving strings then you will have to convert the string back to dates.
</div>

<div>
flex says tstDate is an invalid date 
 
How about this, I have changed my PHP code to return date in milliseconds since 1st Jan 1970 by using UNIX_TIMESTAMP in my sql query and multiplying the result by 1000, I've read that this is a format which Flex can use. &nbsp;Currently my flex object looks like this: 
 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[RemoteClass(alias=&quot;VOLoad&quot;)] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Bindable] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public class VOLoad 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public var id:int; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public var start_date:Date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public var end_date:Date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} 
 
and my PHP object looks like this: 
 
&lt;?php 
class VOLoad { 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public $id; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public $start_date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public $end_date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var $_explicitType = &quot;VOLoad&quot;; 
} 
 
my remote object declaration looks like this in Flex: 
 
&lt;mx:RemoteObject id=&quot;phpService&quot; destination=&quot;zend&quot; source=&quot;MyService&quot; fault=&quot;faultHandler(event)&quot;&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:method name=&quot;getLoads&quot; result=&quot;getMyLoadTableHandler(event)&quot; /&gt; 
&lt;/mx:RemoteObject&gt; 
 
my remote method looks like this: 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;public function getLoads(){ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$result = mysql_query('select id, unix_timestamp(start_date) as start_date, unix_timestamp(end_date) as end_date from `load` where &nbsp;1'); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ret = array(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;while ($row = mysql_fetch_object($result)) { 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tmp = new VOLoad(); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$row-&gt;start_date = 1000 * $row-&gt;start_date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$row-&gt;end_date = 1000 * $row-&gt;end_date; 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tmp-&gt;id = $row-&gt;id; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tmp-&gt;start_date = $row-&gt;start_date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tmp-&gt;end_date = $row-&gt;end_date; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ret[] = $tmp; 
&nbsp; &nbsp; &nbsp;} 
&nbsp; &nbsp; &nbsp;mysql_free_result($result); 
&nbsp; &nbsp; &nbsp;return $ret; 
 
} 
 
The Flex callback function looks like this: 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Bindable] 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;private var myLoadDP:ArrayCollection; 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; private function getMyLoadTableHandler(event:ResultEvent):void 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; { 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myLoadDP = new ArrayCollection(ArrayUtil.toArray(event.result)); 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;} 
 
The datagrid looks like this: 
 
&lt;mx:DataGrid x=&quot;0&quot; y=&quot;0&quot; width=&quot;100%&quot; height=&quot;100%&quot; id=&quot;myLoadDataGrid&quot; editable=&quot;true&quot; dataProvider=&quot;{myLoadDP}&quot; &gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:columns&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:DataGridColumn headerText=&quot;Ref&quot; dataField=&quot;id&quot; editable=&quot;false&quot; width=&quot;25&quot;/&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:DataGridColumn headerText=&quot;Start Date&quot; dataField=&quot;start_date&quot; editorDataField=&quot;selectedDate&quot; width=&quot;50&quot; &gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:itemEditor&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:Component&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:DateField formatString=&quot;DD/MM/YYYY&quot; /&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:Component&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:itemEditor&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:DataGridColumn&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:DataGridColumn headerText=&quot;End Date&quot; dataField=&quot;end_date&quot; editorDataField=&quot;selectedDate&quot; width=&quot;50&quot; &gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:itemEditor&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:Component&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;mx:DateField formatString=&quot;DD/MM/YYYY&quot; /&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:Component&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:itemEditor&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:DataGridColumn&gt; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/mx:columns&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&lt;/mx:DataGrid&gt; 
 
 
 
How do I get the dates to render properly?
</div>

<div>
How are they appearing in flex now?
</div>

<div>
I get an error 
TypeError: Error #1034: Type Coercion failed: cannot convert 1230768000000 to Date. 
 
Is my question unclear?
</div>

<div>
var newDate:Date = new Date(); 
newDate.setTime(1230768000000); 
 
Should do it.
</div>

<div>
OK I understand that you're applying the setTime method to the unix timestamp but I already read that in the actionscript reference. &nbsp;It's the implementation I need help with rather than just the syntax. &nbsp;Look at the VOLoad object defined in actionscript above. &nbsp;How do I tell the datagrid &quot;Render this unix timestamp as a date and when I alter the date with the DateField itemEditor, save the resulting date as a unix timestamp&quot;? 
 
I've come to the conclusion that it requires the labelfunction/parsefunction but I don't know how to use these. &nbsp;Could you take the code I provided and alter it to demonstrate how to achieve what I need please? 

</div>

<div>
I can't as I don't use php so I can't do it. &nbsp;Which is why I am guessing a bit. &nbsp;CF -&gt; Flex over amf does the conversion for you so it woul'd see a date as a date. 
 
 
try this code in php: 
 
&nbsp;$tmp-&gt;start_date = $date(row-&gt;start_date); 
&nbsp;$tmp-&gt;end_date = $date(row-&gt;end_date); &nbsp; 
 
and get rid of the conversion to unix time. &nbsp;I see wats happening php is sending a string not a 'date' &nbsp;see how you go.
</div>

<div>
Yeah I did that originally, remember the post above: 
 
TypeError: Error #1034: Type Coercion failed: cannot convert &quot;2009-01-01 00:00:00&quot; to Date. 
 
I think Flex expects a date string to look like DD-MM-YYYY HH:MM:SS or something along those lines. &nbsp;Maybe one of the other guys has some experience of PHP and Flex. 
 
:(
</div>

<div>
No I mean do that in php not flex. &nbsp;Ie convert it to a date in php before u send to flex.
</div>

<div>
When I sent the datetime field back to flex without the unixtime in the sql query it comes out of the database as a string in the format 2009-01-01 00:00:00 
 
Sending this to flex where the start_date variable is set as type Date results in the same type coersion error: 
 
TypeError: Error #1034: Type Coercion failed: cannot convert &quot;2009-01-01 00:00:00&quot; to Date.
</div>

<div>
But did you actually send a string or a date from PHP 
 
ie: 
 
$tmp-&gt;start_date = $date(row-&gt;start_date); &nbsp; &nbsp;//DATE 
$tmp-&gt;start_date = &quot;2009-01-01 00:00:00&quot;; &nbsp; &nbsp;//STRING 
 
Or is this the same thing in PHP?
</div>

<div>
There isn't a Date type in PHP. &nbsp;It just treats it as a string.
</div>

<div>
Try this loop over the result set and convert to a date in flex before populating the arrayCollection. 
 
And set the php code back to seconds form 1972 

<pre><code class="code-10 nolinks" id="code-265152">&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;
&lt;mx:Application xmlns:mx=&quot;http://www.adobe.com/2006/mxml&quot; layout=&quot;absolute&quot; viewSourceURL=&quot;srcview/index.html&quot; creationComplete=&quot;init()&quot;&gt;
	
	&lt;mx:Script&gt;
		
		&lt;![CDATA[
			import mx.collections.ArrayCollection;
			
			[Bindable] public var ar:ArrayCollection = new ArrayCollection; 
			
			private function init():void{
				var resultFromPhp:Array = new Array;
				
				//add some fake object for testing
				var o:Object = new Object;
				o.name = &quot;Jones911&quot;;
				o.date = 9230768672001;
				resultFromPhp[0] = o;
				o = new Object();
				o.name = &quot;Jones912&quot;;
				o.date = 1250768004440;
				resultFromPhp[1] = o;
				o = new Object();
				o.name = &quot;Jones913&quot;;
				o.date = 9230768000002;
				resultFromPhp[2] = o;
				
				//Loop the array from php and convert to date type from seconds from 1970
				for(var i:int = 0; i &lt; resultFromPhp.length; ++i){
					var tempDate:Date = new Date();
					tempDate.setTime(resultFromPhp[i].date);
					resultFromPhp[i].date = tempDate;
				}
				
				//Do the load here from you VO's
				ar = new ArrayCollection(resultFromPhp);
			}
		]]&gt;
	&lt;/mx:Script&gt;
	&lt;mx:DataGrid x=&quot;148&quot; y=&quot;214&quot; dataProvider=&quot;{ar}&quot; width=&quot;422&quot;/&gt;
	
	
&lt;/mx:Application&gt;
</code></pre>
<a href="https://filedb.experts-exchange.com/incoming/2009/03_w10/112490/Capture.JPG" target="_blank" class="file-inline" title="How it looks (23 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Capture.JPG</a>
</div>

Capture.JPG

<div>
What type of variable should o.date be above? String?
</div>

<div>
I got it successfully converting the Number to a Date successfully using code I found somewhere else. &nbsp;I need to convert the selected date from the datefield to a Number now so I can send to PHP. &nbsp;Sorry, I opened another question. &nbsp;I can delete the other and add it here instead if you prefer? 
 

</div>

<div>
Oh well this is the answer anyway.
</div>

<div>
I tried your method but it is complaining that tempDate cannot be cast as date 
 
 

<pre><code class="code-1 nolinks" id="code-266513">
1067: Implicit coercion of a value of type Date to an unrelated type Class.	
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
Hi, I'm having a problem exchanging dates between MySQL and Flex. &nbsp; 
 
My current setup uses Zend AMF to exchange value objects between PHP and Flex and then I use a mysql database to store the values of these objects. &nbsp; 
 
I have successfully got the Flex app talking to the backend and reading and writing to the database except for the date values. 
 
I'm confused as to which variable type I should use to exchange dates with the database and which type of record to choose in MySQL so I can easily edit the dates in a flex datagrid using a datefield.
</div>
</div>

Hi, I'm having a problem exchanging dates between MySQL and Flex.  

My current setup uses Zend AMF to exchange value objects between PHP and Flex and then I use a mysql database to store the values of these objects.  

I have successfully got the Flex app talking to the backend and reading and writing to the database except for the date values.

I'm confused as to which variable type I should use to exchange dates with the database and which type of record to choose in MySQL so I can easily edit the dates in a flex datagrid using a datefield.

Flex Date exchange with PHP and MySQL

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Apache Flex is a highly productive, open source application framework for building and maintaining expressive web applications that deploy consistently on all major browsers, desktops and devices (including smartphones, tablets and television). It provides a modern, standards-based language and programming model that supports common design patterns suitable for developers from many backgrounds. Flex applications can be deployed to the Adobe Player in the browser, Adobe AIR on desktop and mobile devices or to native Android, iOS, Windows or Mac applications.

Apache Flex

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.