Solved: Microsoft Dynamics CRM email template add large date format like Thursday, September 7, 2017 at 12:00PM
I got a chance to work on the Microsoft Dynamics. I was very new to Dynamic CRM and a lot of challenges. I faced two major challenges
1. Create custom email template with Microsoft Dynamics.
2. Add a long date format into the email template eg: Thursday, September 7, 2017, at 12:00 PM.
In this article, I will show how I able to figure out large date format issue. So we all know it’s not possible in Microsoft Dynamics to add date format like Thursday, September 7, 2017, at 12:00 PM. There are different third party tools which can help you, But they were very expensive. So after pulling my hairs couple of days, I figured out this.
I created a new column in my database with string format. So as I was getting data into my database (MY SQL), I converted the actual date format into a format I need like (Thursday, September 7, 2017, at 12:00 PM). So then I synced my database with the MS Dynamic CRM and showed that string long date format into the email template instead of showing that boring date format.
Please check the enclosed attachment of my email template, Which is fully dynamic and attractive too.