Format date using SSRS expression

A very common need is to format date using the 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

The post Format date using SSRS expression appeared first on NevoiTech Blog.