/ Microsoft / Format date using SSRS expression

Format date using SSRS expression

Learn, share and spread knowledge

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

0 POST COMMENT

Send Us A Message Here

Your email address will not be published. Required fields are marked *