This discussion is archived
3 Replies Latest reply: Jul 8, 2013 11:19 AM by earthworm RSS

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

mobra Journeyer
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points