6 Replies Latest reply: Jul 30, 2013 8:44 AM by Myvizhi Selvi RSS

    Date Format issue

    Myvizhi Selvi

      Hi All,

       

      I have an issue in the Date format while passing the date into the VO as a parameter from the Controller.

      I have created  MessageTextInput as Date Data type.

      In Controller while getting this value as follows:

       

      String dateFrom = pageContext.getParameter("DateFrom");
      String dateTo = pageContext.getParameter("DateTo");

       

      Then am converting this String into Date Format to pass it in to VO as a parameter as follows:

       

      Date dateFrom1 = null;
      Date dateTo1 = null;
      try
      {
      SimpleDateFormat f = new SimpleDateFormat("DD-Mon-YYYY");
      dateFrom1 = (Date)f.parse(dateFrom);
      dateTo1 = (Date)f.parse(dateTo);
      }
      catch(Exception e){
      System.out.println("Exception in dateFrom");
      }
      setNamedWhereClauseParam("p_cm_div",cmDiv);
      setNamedWhereClauseParam("p_date_from",dateFrom1);
      setNamedWhereClauseParam("p_date_to",dateTo);

       

      But am getting the following error while passing Date from the page.

       

      Error

      oracle.jbo.domain.DataCreationException: JBO-25009: Cannot create an object of type:oracle.jbo.domain.Date with value:27-Jul-2013

       

      Many thanks in Advance.

       

      Thanks and Regards,

      Myvizhi