I need some help with switching the format from DD-MM-YYYY or MM-DD-YYYY to ISO Standard (YYYY-MM-DD)in JavaScript. I'm using this on a custom URL Button.
This is what i'm doing, and It is working fine for US date formats but not working for EU dates. I get invalid date error.
{!REQUIRESCRIPT("/soap/ajax/30.0/connection.js")}
var Lastdate = new Date('{!ServiceContract.EndDate}');
How can I instantiate a Date when using a different locale?
Build a utility function to convert like this...
// accepts format like dd/mm/yyyy
function parseDate(datestr) {
var arr = datestr.match(/(\d+)/g);
var y = parseInt(arr[2]);
var m = parseInt(arr[1])-1;
var d = parseInt(arr[0]);
return new Date(y,m,d);
}
//test
parseDate('23/07/1980'); // => Wed Jul 23 1980 00:00:00 GMT-0400 (EDT)
Dataloader.io has an advanced settings pain on the run page of their wizard.
You can change the expected day-month order here.
Most Salesforce ETL tools have some setting like this.
If that doesn't fix it, then it is likely that something actually wrong with the date format itself, such as the delimiters between the different date elements not being acceptable, or other characters corrupting the date.
For reference here is the full settings pain:
Best Answer
Yes, it will give an issue due to locale.
So, better retrieve year, month and day portion from the date and create a Date instance based on those parameters.
It will solve locale related issues.