{"id":23899,"date":"2020-04-10T10:27:44","date_gmt":"2020-04-10T10:27:44","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=23899"},"modified":"2020-04-10T10:29:29","modified_gmt":"2020-04-10T10:29:29","slug":"converting-javascript-date-to-sage-crm-date","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/","title":{"rendered":"Converting JavaScript date to Sage CRM date"},"content":{"rendered":"\n

Hello everyone! In Sage CRM <\/a>date fields helps user to track when a particular record is been created or updated. Some additional date fields like closing date on opportunity or Due date on communication plays vital role in defining business logic and escalation as well.<\/p>\n\n\n\n

New Stuff:<\/em><\/strong> Sage CRM\u2019s Data loading issue on Mobile browser<\/a><\/p>\n\n\n\n

Consider a business scenario where an opportunity target close date should be set to after 3 months from opportunity open date. For example if I create an opportunity with open date say 1 Jan, 2020 then target close date should be set to 1 April, 2020. Which might be pretty simple when you follow the below steps.
1. Read value of Opportunity open date
2. Add 3 months with the current date value
3. Store the Calculated date into Closed by field.<\/p>\n\n\n\n

\/\/Read value of opportunity open date field\nvar sOpenDate =new Date($('#oppo_opened').val());\n\/\/add some months to the date\nvar ClosedDate= new Date(sOpenDate.setMonth(sOpenDate.getMonth()+3));\n$(\"#oppo_targetclose\").val(ClosedDate);<\/code><\/pre>\n\n\n\n\"Invalid<\/a>\n
Invalid Date Format<\/i><\/center><\/font>\n\n\n\n
But this will still not allow user to Save the opportunity record instead display validation message related to Incorrect Date format. <\/p>\n\n\n\n\"Validation<\/a>\n
Validation Message<\/i><\/center><\/font>\n\n\n\n
This is because we have not added anything to handle the date format. Hence, in our blog we will explain how you can add Date Format. Just go ahead and add the below function to you ClientFunc.js.<\/p>\n\n\n\n
function FormatDate(pmDate)\n{\ndateFormat = crm.CurrentUser.userpref_dateformat.toLowerCase();\nconsole.log(dateFormat);\n\nvar mm = pmDate.getMonth() + 1;\n            var dd = pmDate.getDate();\n            var year = pmDate.getFullYear();\n\nif (dateFormat == \"mm\/dd\/yyyy\")\n{\n\tif (mm < 10)\n\t{\n\t\tif (dd < 10)\n\t\t{\n\t\t\tFormattedDate = \"0\"+mm + \"\/\" + \"0\" + dd + \"\/\" + year;\n\t\t}\n\t\telse\n\t\t{\n\t\t\tFormattedDate = mm+\"\/\" + \"0\" +dd + \"\/\" + year;\n\t\t}\n\n\t}\n\telse\n\t{\n\t\tFormattedDate = mm + \"\/\" + dd + \"\/\" + year;\n\t}\n}\nif (dateFormat == \"mm.dd.yyyy\")\n{\n\tif (mm < 10)\n\t{\n\t\tif (dd < 10)\n\t\t{\n\t\t\tFormattedDate = \"0\"+mm + \".\" + \"0\" + dd + \".\" + year;\n\t\t}\n\t\telse\n\t\t{\n\t\t\tFormattedDate = mm+\".\" + \"0\" +dd + \".\" + year;\n\t\t}\n\t}\n}\nelse\n\t{\n\t\tFormattedDate = mm + \".\" + dd + \".\" + year;\n\t}\n\nif (dateFormat == \"dd.mm.yyyy\")\n{\n\tif (mm < 10)\n\t{\n\t\t\tif (dd < 10)\n\t\t\t{\n\t\t\t\tFormattedDate = \"0\"+dd + \".\" + \"0\" +mm + \".\" + year;\n\t\t\t}\n\t\t\telse\n\t\t\t{\n\t\t\t\tFormattedDate = dd+\".\" + \"0\" +mm+ \".\" + year;\n\t\t\t}\n\t}\n}\nelse\n{\n\tFormattedDate = dd + \".\" + mm + \".\" + year;\n}\nif (dateFormat == \"dd\/mm\/yyyy\")     \/\/dd\/MM\/yyyy\n{\n\tif (mm < 10)\n\t{\n\t\tif (dd < 10)\n\t\t{\n\t\t\tFormattedDate = \"0\"+ dd + \"\/\" + \"0\" + mm + \"\/\" + year;\n\t\t}\n\t\telse\n\t\t{\n\t\t\tFormattedDate = dd + \"\/\" + \"0\" + mm + \"\/\" + year;\n\t\t}\n\t}\n\telse\n\t{\n\t\tFormattedDate = dd + \"\/\" +  mm + \"\/\" + year;\n\t}\n}\nreturn FormattedDate;\n}<\/code><\/pre>\n\n\n\n
Next, update your code to include the above date format function.<\/p>\n\n\n\n
\/\/Read the Opportunity open Date \nvar sOpenDate =new Date($('#oppo_opened').val());\n\/\/add some months to the date\nvar ClosedDate= new Date(sOpenDate.setMonth(sOpenDate.getMonth()+3));\nClosedDate= FormatDate(ClosedDate);\n$(\"#oppo_targetclose\").val(ClosedDate);\t<\/code><\/pre>\n\n\n\n
Now you can see that Closed By <\/strong>field value is set in Standard Sage CRM format, refer below screenshot:<\/p>\n\n\n\n\"Correct<\/a>\n
Correct Date Format<\/i><\/center><\/font>\n\n\n\n
Now, you can handle any date format by using the function. Hope this information helps.<\/p>\n\n\n\n
About Us<\/strong><\/span>\n<\/p>\n\n\n\n
Greytrix<\/a> – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.<\/p>\n\n\n\n
Greytrix<\/a> helps in upgrading Sage ERP and CRM to the latest version and provides migration for Sage Intacct from Sage 300, Sage 100, Sage 50 and QuickBooks<\/a>; for Sage 100, Sage 300 (Sage Accpac), Sage X3 from Sage Pro<\/a>, Sage 50 US<\/a>, Sage 50 CA<\/a>, Sage 50 US, Sage Business Works, Sage Business Vision<\/a> and QuickBooks<\/a>; for Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer<\/a><\/p>\n\n\n\n
For more information on Sage ERP \u2013 CRM migration solutions, please contact us at erpmig@greytrix.com<\/a>. We will like to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hello everyone! In Sage CRM date fields helps user to track when a particular record is been created or updated. Some additional date fields like closing date on opportunity or Due date on communication plays vital role in defining business logic and escalation as well. New Stuff: Sage CRM\u2019s Data loading issue on Mobile browser\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-23899","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nConverting JavaScript date to Sage CRM date - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Converting JavaScript date to Sage CRM date - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Hello everyone! In Sage CRM date fields helps user to track when a particular record is been created or updated. Some additional date fields like closing date on opportunity or Due date on communication plays vital role in defining business logic and escalation as well. New Stuff: Sage CRM\u2019s Data loading issue on Mobile browser\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-10T10:27:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-10T10:29:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/\",\"name\":\"Converting JavaScript date to Sage CRM date - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg\",\"datePublished\":\"2020-04-10T10:27:44+00:00\",\"dateModified\":\"2020-04-10T10:29:29+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Converting JavaScript date to Sage CRM date\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Converting JavaScript date to Sage CRM date - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/","og_locale":"en_US","og_type":"article","og_title":"Converting JavaScript date to Sage CRM date - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Hello everyone! In Sage CRM date fields helps user to track when a particular record is been created or updated. Some additional date fields like closing date on opportunity or Due date on communication plays vital role in defining business logic and escalation as well. New Stuff: Sage CRM\u2019s Data loading issue on Mobile browser\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2020-04-10T10:27:44+00:00","article_modified_time":"2020-04-10T10:29:29+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/","name":"Converting JavaScript date to Sage CRM date - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg","datePublished":"2020-04-10T10:27:44+00:00","dateModified":"2020-04-10T10:29:29+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2020\/04\/Img-2.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2020\/04\/10\/converting-javascript-date-to-sage-crm-date\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Converting JavaScript date to Sage CRM date"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/402abe5da07cd7f9bfeb6acfa41fae39","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/23899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=23899"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/23899\/revisions"}],"predecessor-version":[{"id":23909,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/23899\/revisions\/23909"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=23899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=23899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=23899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}