{"id":20451,"date":"2019-09-11T12:18:31","date_gmt":"2019-09-11T12:18:31","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=20451"},"modified":"2019-09-11T12:18:51","modified_gmt":"2019-09-11T12:18:51","slug":"print-current-local-date-time-in-dynamics-365-crm-word-template","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/09\/print-current-local-date-time-in-dynamics-365-crm-word-template\/","title":{"rendered":"How to print current local date and time in Dynamics 365 CRM Word Template"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

Dynamics 365 CRM word template allows users to make their own standardized entity specific template to represent data according to their business standards.<\/p>\n

It is a requirement for businesses today to send quotation of their products or services to their customer. For this they mostly prefer to use Microsoft word template with their own set of standards on which they can create the required quotation against any specific customer easily. However, the quotation must have the current date and time on which it was generated.<\/p>\n

We think that this can be very much achieved by making use of Microsoft world macros. But as we have no experience in macros we thought of a workaround option that we can use to show current local date and time on the document generated through word template.<\/p>\n

So in this blog, we will show how we can get the current local date & time in word template:<\/p>\n

Steps 1 – Go to Customization >> Entities >> Preferred Entity as Quote >> Fields >> New<\/p>\n

\"Dynamics<\/p>\n

Step 2 – Create a date & time field on the CRM as shown below:<\/p>\n

Name: Today\u2019s Date<\/p>\n

Data Type: Date and Time<\/p>\n

Field Type: Calculated<\/p>\n

Behavior: User Local<\/p>\n

Format: Date only or Date and Time as per requirement<\/p>\n

Next, click Edit button next to calculated field.<\/p>\n

\"Dynamics<\/p>\n

Step 3 – Calculated field allows us to set the value of field as per the conditions provided but we want today\u2019s date without any conditions. So in the action tab use the NOW() function which will give the current date and time.<\/p>\n

\"Dynamics<\/p>\n

Step 4 – Download Word Template Settings >> Templates >> Document Templates >> New or Any entity >> Ribbon Button >> Excel Template or follow<\/a> Microsoft Doc to download Word Template.<\/p>\n

Step 5 – Go to the word template downloaded from Dynamics 365 CRM and on the Developer tab (if developer tab is not visible click here<\/a>) click the XML Mapping Pane.<\/p>\n

Step 6 – Place Todays\u2019 Date field on the word template as shown below:<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

Step 7 – Upload the word template on CRM and export it from individual record or from home grid or from advanced find record list.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

Step 8 – Result.<\/p>\n

\"Dynamics<\/p>\n

Please note: The format for date & time will be same as in CRM.<\/p>\n

Conclusion<\/strong><\/h2>\n

In this way, we can create the custom field Today\u2019s date<\/strong> to store the current date and time. So whenever it is exported we will always get the current local date and time.<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Dynamics 365 CRM word template allows users to make their own standardized entity specific template to represent data according to their business standards. It is a requirement for businesses today to send quotation of their products or services to their customer. For this they mostly prefer to use Microsoft word template with their own\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":20462,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1937,1938,18,24,25],"tags":[1939,1936],"class_list":["post-20451","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-document-template","category-dynamics-365-crm-word-template","category-dynamics-365-v9-2","category-dynamics-crm-2016","category-dynamics-crm-2016-update-1","tag-document-template","tag-dynamics-365-crm-word-template"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/20451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=20451"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/20451\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/20462"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=20451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=20451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=20451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}