Format date using SSRS expression

A very common need is to format date using SSRS expression. I have formalized two expressions which helps you to meet a very basic requirement. It works for SSRS reports of Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012 as both versions use the SSRS reports.

For date or date time data types:

=Format(First(Fields!PurchOrderDate.Value,”PurchPurchaseOrderDS”), “dd/MM/yyyy”)

For string data type:

=Format(CDate(First(Fields!Payment.Value,”VendInvoiceDocumentDS”)),”dd/MM/yyyy”)

The function CDate(<value>) that I have used above converts the String value to Date value. And then the function Format(<value>, <format string expression>) returns a string formatted according to instructions contained in a format String expression.

So, this is how you can format date using SSRS expression in D365FO or in  AX 2012. If this helps you, please Like, Comment and Share to help other people.

If you found any ambiguity or a better solution, please feel free to ask.

Blog: Click here

YouTube: Click here

GitHub: Click here

Winners never quit and quitters never win. – Vince Lombardi

Moeen Ahmed Sultan

I am Moeen Ahmed Sultan from Pakistan, an Independent technical consultant for Microsoft business applications. I am Microsoft Certified Professional, I always seek opportunities to showcase my skills in the extensive field of Computer Science. I have successfully championed to the enterprise by working in extensive areas including Microsoft Power Apps, Microsoft Dynamics AX 2012, Microsoft Dynamics 365 for Finance & Operations, and Microsoft Share Point Online thereby fueling the industry-wide transition.