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