+ Start a Discussion

Date insert

I’m having an issue with inserting a date into a custom Date field. We are parsing through a file and extracting information. One of the pieces of information that is being extracted is a date value in the following format – mm-dd-yy.


I am currently setting this as a Date – Date dt = date.newinstance(y,m,d). But when I run this program to insert these values to a custom Date field, the program fails and I get the following error message - Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, mailing_date: invalid date


I used the Dev. Console to run this block of code to see what the date format is being set as:


Date dts = date.newinstance(12,4,24);



The result is - 09:32:17:212 USER_DEBUG [2]|DEBUG|0012-04-24 00:00:00


My assumption was that since I am making this a Date and not a DateTime, that the time stamp would not be included. Also, the year is showing as 0012, rather then just “12” or “2012”. I thought that the Date type has a "format" method, but apparently it doesn't, only DateTime does.


I cannot figure out what I am doing wrong. Any help would be greatly appreciated.


Thank you once again,


Wes Cooper


Here is a link to the documentation on creating a new instance of a Date object using year, month and day.