You need to sign in to do that
Don't have an account?
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);
system.debug(dts);
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.
http://www.salesforce.com/us/developer/docs/apexcode/Content/apex_methods_system_date.htm?SearchType=Stem&Highlight=Date|Dates|dates|date|DATE