{"id":2354,"date":"2019-09-29T11:12:37","date_gmt":"2019-09-29T11:12:37","guid":{"rendered":"https:\/\/staging.txtbox.in\/docs\/salesforce\/?post_type=lsvr_faq&#038;p=2354"},"modified":"2019-09-29T11:12:37","modified_gmt":"2019-09-29T11:12:37","slug":"72-how-to-get-the-standard-uk-format-of-dd-mm-yyyy-for-date-fields-in-templates","status":"publish","type":"lsvr_faq","link":"https:\/\/staging.txtbox.in\/docs\/salesforce\/faq\/72-how-to-get-the-standard-uk-format-of-dd-mm-yyyy-for-date-fields-in-templates\/","title":{"rendered":"72. How to get the standard UK format of DD\/MM\/YYYY for date fields in templates?"},"content":{"rendered":"\n<p>Dates can be stored in various formats in the Salesforce org according to the user\u2019s preference &amp; country. Though you see the date in your preferred format, it will be fetched with the code in the standard format of \u201cYYYY-MM-DD\u201d only (it gets automatically converted to the above-mentioned format and cannot be changed).<br>However, there is a solution for accessing the date field in the preferred format in SMS Template.<\/p>\n\n\n\n<p>Create a new formula field, of type Text, on the same object.The Formula value should be \u2013<br>TEXT( DAY(Date Field)) &amp; \u201c\/\u201d &amp; TEXT(MONTH(Date Field)) &amp; \u201c\/\u201d&amp; TEXT(YEAR(Date Field)).<br>This field will store the text version of Date Field in dd\/mm\/yyyy format. You can use this formula field in SMS Template in place of the Date field and view results as per your requirement.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dates can be stored in various formats in the Salesforce org according to the user\u2019s preference &amp; country. Though you see the date in your preferred format, it will be fetched with the code in the standard format of \u201cYYYY-MM-DD\u201d only (it gets automatically converted to the above-mentioned format and cannot be changed).However, there is [&hellip;]<\/p>\n","protected":false},"author":5,"template":"","meta":{"footnotes":""},"lsvr_faq_cat":[320],"lsvr_faq_tag":[],"class_list":["post-2354","lsvr_faq","type-lsvr_faq","status-publish","hentry","lsvr_faq_cat-message-delivery"],"_links":{"self":[{"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/lsvr_faq\/2354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/lsvr_faq"}],"about":[{"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/types\/lsvr_faq"}],"author":[{"embeddable":true,"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":1,"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/lsvr_faq\/2354\/revisions"}],"predecessor-version":[{"id":2355,"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/lsvr_faq\/2354\/revisions\/2355"}],"wp:attachment":[{"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/media?parent=2354"}],"wp:term":[{"taxonomy":"lsvr_faq_cat","embeddable":true,"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/lsvr_faq_cat?post=2354"},{"taxonomy":"lsvr_faq_tag","embeddable":true,"href":"https:\/\/staging.txtbox.in\/docs\/salesforce\/wp-json\/wp\/v2\/lsvr_faq_tag?post=2354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}