3 Replies Latest reply: Jul 8, 2013 1:19 PM by earthworm RSS

    Using a datepicker with format mask MM/YYYY gives error on submit

    mobra

      I'm trying to use a datepicker with the format MM/YYYY.

       

      The item is linked to a database column of type DATE.

       

      The items displays correctly (month and year), but when submitting the page, I get an "ORA-01843: not a valid month" error from the built-in DML process.

       

      Shouldn't Apex apply the same date format mask to the item value when trying to save it to the database?

       

       

      - Morten

       

      http://ora-00001.blogspot.com