Hi Jeremiah,

I tried with NOW () :

opp.CloseDate = "{!NOW()}"; produces Failed to create 'New Opportunity' with error: {faultcode:'soapenv:Client', faultstring:''01/07/2009 15:04' is not a valid value for the type xsd:date', } I support you : "What's the solution ?"   !!! Rup

You can use: -

opp.CloseDate = New Date();

This will set current date to CloseDate.

I was trying to solve the same problem today, your code provided a good start for me. I ended up writing the following functions:

function fixTime(time){
   if(time < 10) {time = "0" + time};
   return time;
}
function fixDate(date){
  var Month = fixTime(date.getMonth() + 1);
  var Day = fixTime(date.getDate());
  var UTC = date.toUTCString();
  var Time = UTC.substring(UTC.indexOf(':')-2, UTC.indexOf(':')+6);

  var Minutes = fixTime(date.getMinutes());
  var Seconds = fixTime(date.getSeconds());
  return date.getYear() + "-" + Month + "-" + Day + "T" + Time; 
}

The date object that javascript uses has a different format than the one used by Salesforce. These functions convert the format.

QR.Delivered_Date__c= fixDate(new Date());

Here is my own solution :

function right(str, len) { return str.substring(str.length-len, str.length) } function mynow() { d = new Date(); return right("00"+d.getFullYear(), 4) + "-" + right("00"+(1+d.getMonth()), 2) + "-" + right("00"+d.getDate(), 2); // format "2009-007-02" }

 Call this like this :

opp.CloseDate= mynow();

I think Salesforce requires the full four-digit year ... might want to use date.getFullYear() instead of date.getYear() as shown below.

function fixTime(time){ if(time < 10) {time = "0" + time}; return time; } function fixDate(date){ var Month = fixTime(date.getMonth() + 1); var Day = fixTime(date.getDate()); var UTC = date.toUTCString(); var Time = UTC.substring(UTC.indexOf(':')-2, UTC.indexOf(':')+6); var Minutes = fixTime(date.getMinutes()); var Seconds = fixTime(date.getSeconds()); return date.getFullYear() + "-" + Month + "-" + Day + "T" + Time; }

Hi RupB,

I ran into the same error, did you get the resolution for this?

Thanks in anticipation

Hi,

I checked out your JAVA fix and noticed that it may just be the solution to this brickwall I ran into. I have the following custom button OnClick Javascript code on a sample object that should imprint both Date and Time values on a DateTime field. I did use the new Date() syntax but it only works for Date fields and not DateTime. I was wondering, how your post would fit into what I've formulated. Thanks in advance!

{!REQUIRESCRIPT("/soap/ajax/22.0/connection.js")} 
var v=new sforce.SObject("Opportunity"); 
v.JavaDateButtonTest__c="{!Opportunity.JavaDateButtonTest__c}"; 
v.id = "{!Opportunity.Id}"; 
if((v.JavaDateButtonTest__c=='')) 
{ 
var date = new Date('{!TODAY()}'); 
v.JavaDateButtonTest__c=date; 
result=sforce.connection.update([v]); 
}

-----------------------------------------------------------

function fixTime(time){
   if(time < 10) {time = "0" + time};
   return time;
}
function fixDate(date){
  var Month = fixTime(date.getMonth() + 1);
  var Day = fixTime(date.getDate());
  var UTC = date.toUTCString();
  var Time = UTC.substring(UTC.indexOf(':')-2, UTC.indexOf(':')+6);

  var Minutes = fixTime(date.getMinutes());
  var Seconds = fixTime(date.getSeconds());
  return date.getFullYear() + "-" + Month + "-" + Day + "T" + Time; 
}

 -----------------------------

I also got this from another site and I'm not sure if this is usable for what I cited above:

http://www.ladysign-apps.com/blog/code/salesforce/salesforce-datetime-functions/comment-page-1/#comment-483

/**
* Set Javascript Date Time to Salesforce Date Time;
* @param dateTimeObj - date time string
* @return salesforce date time object
**/
function setStringToDateTime(dateTimeObj){
    var dateTimeObj;
 
    if (dateTimeObj != null) {
        dateTimeObj = sforce.internal.stringToDateTime(dateTimeObj);
    }
 
    return dateTimeObj;
}