sql

how to format time using dataset fields in SSRS report

how to format time using dataset fields in SSRS report, format time using dataset fields in the SSRS report
Share it:

how to format time using dataset fields in SSRS report

format time using dataset fields in the SSRS report

Description:-

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


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")
Share it:

sql

Post A Comment:

0 comments: