Format a date in SSRS report

Format a date in SSRS report

MCP · Azure DevOpsYour delivery board, readable by an agentMCP · DataverseOne consent, and the data layer opensMCP · Dynamics 365 F&OConnecting F&O to an agent Microsoft hasn’t documented
After adding a Date parameter in contract class of SSRS report it starts showing in report's parameters node with Data type DateTime.























There is no option to make it either short date or format a date at parameter level. You can use following expression in report design where this parameter has been used in design, mostly in textbox.

=format(Parameters!Dataset1_AsPerDate.Value,"dd/MM/yyyy")


Happy Daxur!ng
Previous article← The data source is not embedded within a (parent) data source.
Discussion

Ask a question or leave feedback

This is a review interaction. The WordPress version will store, thread and moderate comments.

Thanks — submitted for moderation in this review.
Search the whole site · Ctrl/⌘ + K