Most of the time we need to set datatime field value in crm, but problem is that ms crm datetime file format is different from sql server date format so i have written a some js to get date part from sqlserver datetime field.
\nwe can pass datetime value to this function and it will return date part from datetime value.
\nfunction GetDate(strCrmFormatDate)
\n{
\nvar newDate=new Date();
\nvar indexofT=strCrmFormatDate.indexOf(“T”);
\nvar strdatepart=strCrmFormatDate.substring(0,indexofT);
\nvar month=strdatepart.substring(5,7);
\nvar year=strdatepart.substring(0,4);
\nvar day=strdatepart.substring(8);
\nif(month.substring(0,1)==’0′)
\n{
\nmonth=month.substring(1);
\n}<\/p>\n
newDate.setMonth(parseInt(month)-1);
\nnewDate.setFullYear(year);
\nnewDate.setDate(day);
\nreturn newDate;
\n}<\/p>\n","protected":false},"excerpt":{"rendered":"
Most of the time we need to set datatime field value in crm, but problem is that ms crm datetime file format is different from sql server date format so i have written a some js to get date part from sqlserver datetime field. we can pass datetime value to this function and it will return date part from datetime… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/48"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=48"}],"version-history":[{"count":0,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/48\/revisions"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=48"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=48"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=48"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}