D365 F&O Solutions Dynamics AX Format Time using Dataset fields in SSRS report

Format Time using Dataset fields in SSRS report

Umesh Patel 10:17:00 AM Dynamics AX

Description:-

In this article we will see about how to format time using dataset fields in SSRS report. here is the expression to format Time using Dataset fields in SSRS report.

Expression:-

Format(IIF(Fields!New_Time.Value = "NO CHANGE","00:00",Fields!New_Time.Value),"HH:mm tt")  

Or

Format(IIF(Fields!New_Time.Value = "NO CHANGE","00:00",Fields!New_Time.Value),"HH:MM tt")

Author : Umesh Patel

Thanks for comments.....