Using JS Remote Objects, I'm trying to INSERT a record that has a date field as a required field (an Opportunity). I am getting this value from a user input, which I'm using JQuery.validate to validate that it is in date format. The string can look like either:
12/12/2016 or 2016/12/12
This was rejected as an invalid type. Looking at how to format strings in the SF API docs:
To insert record into Date or Date Time field using Data Loader:
1) "Date" type field accept either one of below format:
yyyy-mm-dd
yyyy-mm-dd hh:mm:ss
yyyy-mm-ddThh:mm:ssZ
yyyy-mm-ddThh:mm:ss.sssZ
I tried inputting the date as 2016-12-12, still didn't work.
How can I, in JS, supply a value that the API will accept?
BTW, I'm just using the basic create JS Remote Object method:
OpportuntyObjectModel.create({
name: 'oppName',
CloseDate: '2016-12-12',
StageName: 'Engagement'
}
)