Issue with Date Field on Form

[dlbjr]

I am using Oracle. I have date data coming into a form through ajax in the following sample format: "4/30/2008". The date fields had been rendering fine with the data coming from the ajax until roughly one week ago. Now the date fields are empty, although data is in the json for it when the form loads. This is happening on all forms with a date field and their is a value in the json for that field name. Any idea what has happened?

Thanks for any assistance,

Dave

Sample JSON

{ success: true, data: {projectid: "2008072414204908500",projectdesc: "Standardization of the Calibration Procedure for the VMI Breaker Lifts ",projecttypeid: "2007111508112496803",statusid: "1",enteredon: "7/24/2008 2:20:56 PM",enteredby: "A205387",estsav: "0",estcost: "0",problem: "",objective: "To Improve Calibration Time",apid: "",capitalrequired: "0",startedon: "7/7/2008",assignedto: "A205387" }}

Sample Date Field using "startedon" value from json above

var strDateShortFormat = 'Y M d';
 
var dtm_Start = new Ext.form.DateField( {
id : 'PD7_' + strProject,
name : 'startedon',
allowBlank : true,
width : 100,
fieldLabel : 'Start Date',
format : strDateShortFormat
});

[devnull]

Did you upgrade from 2.0.2 to 2.1?

[dlbjr]

Currently using Version 2.0. I just updated it to 2.1.

Having same issue with both versions

[devnull]

2.1 has a known bug with dates, and theres a fix posted somewhere...

[Animal]

The date string "7/7/2008" cannot be parsed by the format 'Y M d' can it? Read the docs.

You'd use "j/n/Y"

[dlbjr]

Animal,

I created a formatdate function in oracle to output any date for JSON formated as "07/24/2008". It fixed the issue. Thanks for the assistance. I found out the Oracle DBA changed the language format on the oracle box.

dlbjr