<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Date formatting</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/date-formatting</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/date-formatting/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tholmes66 on Date formatting</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/date-formatting#p21183</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/date-formatting#p21183</guid>
        	        	<description><![CDATA[<p>I have spent an excruciating amount of time looking through the forums trying to find an answer to my problem.</p>
<p>The last guy who posted the same probl;em did not get any help, maybe I will have better luck:</p>
</p>
<p>Here is the error:&#160; <a class="errorSource a11yFocus " title="var m=b.jgrid.formatter.date.monthNames,a=b.jgrid.formatter.date.AmPm,r=function(u,B){if(u===0){if(B==12)B=0}else if(B!=12)B+=12;return B};c=0;for(e=f.length;c&#60;e;c++){if(f[c]==" target="_blank">var m=b.jgrid.formatter.date.monthName...]!==undefined)i[f[c].toLowerCase()]= </a></p>
<p>The date data coming back in the array is per Java is MM/dd/yyyy which is 01/31/2010 format.</p>
</p>
<p>The colModel format is as follows:</p>
<p>{sortable:true, name:&#39;requestDate&#39;, index:&#39;requestDate&#39;, width:90, sorttype:&#39;date&#39;, datefmt:&#39;m/d/Y&#39;},</p>
</p>
<p>Over the course of 2 days of testing nothing has worked.</p>
<p>1) I tried chaning the date format coming back to Y-m-d format per the grid.</p>
<p>I got the data in Y-m-d format, but still would nto sort as a date.</p>
</p>
<p>2) tried #1 and then</p>
<p>$("#list").jqGrid(&#39;setColProp&#39;,&#39;requestDate&#39;,{sorttype:&#39;date&#39;, formatter:&#39;date&#39;, datefmt: &#39;m/d/Y&#39;});</p>
<p>to see if my date would change format, and then sort, but this gave me another formatter undefined issue.</p>
</p>
<p>3) I tried mm/dd/yyyy in the colModel and that did not work.</p>
</p>
<p>I&#39;ve tried a dozen other things I saw on here, and none of them worked.</p>
</p>
<p>Any help would be much greatly appreciated.&#160;</p>
</p>
<p>Thanks!</p>
</p>
<p>3) I tried adding code so that:</p>
]]></description>
        	        	<pubDate>Mon, 06 Dec 2010 22:44:59 +0200</pubDate>
        </item>
</channel>
</rss>