1. #1
    Sencha User dlbjr's Avatar
    Join Date
    Oct 2007
    Location
    Cache, OK USA
    Posts
    281
    Vote Rating
    3
    dlbjr is on a distinguished road

      0  

    Default Issue with Date Field on Form

    Issue with Date Field on Form


    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
    Code:
    { 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
    Code:
    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
    });
    dlbjr - David L. Bryant Jr.

    Owner of
    dlbjr Technology Consulting
    Web2 System Developer & Consultant
    Focused on C.I. - Six Sigma - Shingo - Lean Technologies
    dlbjr.consulting@gmail.com

    Owner of:
    Attractive Graphics - "custom screen printing"
    attractivegraphicscsp@gmail.com

  2. #2
    Ext User
    Join Date
    Jul 2007
    Posts
    3,128
    Vote Rating
    1
    devnull is an unknown quantity at this point

      0  

    Default


    Did you upgrade from 2.0.2 to 2.1?

  3. #3
    Sencha User dlbjr's Avatar
    Join Date
    Oct 2007
    Location
    Cache, OK USA
    Posts
    281
    Vote Rating
    3
    dlbjr is on a distinguished road

      0  

    Default Version 2.0

    Version 2.0


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

    Having same issue with both versions
    dlbjr - David L. Bryant Jr.

    Owner of
    dlbjr Technology Consulting
    Web2 System Developer & Consultant
    Focused on C.I. - Six Sigma - Shingo - Lean Technologies
    dlbjr.consulting@gmail.com

    Owner of:
    Attractive Graphics - "custom screen printing"
    attractivegraphicscsp@gmail.com

  4. #4
    Ext User
    Join Date
    Jul 2007
    Posts
    3,128
    Vote Rating
    1
    devnull is an unknown quantity at this point

      0  

    Default


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

  5. #5
    Sencha - Ext JS Dev Team Animal's Avatar
    Join Date
    Mar 2007
    Location
    Notts/Redwood City
    Posts
    30,505
    Vote Rating
    52
    Animal has a spectacular aura about Animal has a spectacular aura about Animal has a spectacular aura about

      0  

    Default


    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"

  6. #6
    Sencha User dlbjr's Avatar
    Join Date
    Oct 2007
    Location
    Cache, OK USA
    Posts
    281
    Vote Rating
    3
    dlbjr is on a distinguished road

      0  

    Default Animal - Thanks - Igot it working

    Animal - Thanks - Igot it working


    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
    dlbjr - David L. Bryant Jr.

    Owner of
    dlbjr Technology Consulting
    Web2 System Developer & Consultant
    Focused on C.I. - Six Sigma - Shingo - Lean Technologies
    dlbjr.consulting@gmail.com

    Owner of:
    Attractive Graphics - "custom screen printing"
    attractivegraphicscsp@gmail.com

Thread Participants: 2