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.....

:)

:(

hihi

:-)

:D

=D

:-d

;(

;-(

@-)

:P

:o

:>)

(o)

:p

:-?

(p)

:-s

(m)

8-)

:-t

:-b

b-(

:-#

=p~

$-)

(y)

(f)

x-)

(k)

(h)

cheer