D365 F&O Solutions Dynamics AX Set Date,Hours,Minutes in SSRS Report

Set Date,Hours,Minutes in SSRS Report

Description:-

In this article we will see about how to set Execution date and time like I want to set date and after hours and minutes in SSRS report. here is the expression to set in SSRS report.

Expression:-

=Format(Globals!ExecutionTime,"MM-dd-yyyy" & " ") 
& CStr(Hour(Globals!ExecutionTime))  & ":"
& CStr(Minute(Globals!ExecutionTime))

Or

=Format(Globals!ExecutionTime,"MM-dd-yyyy" & " ") 
& Right("00" & CStr(Hour(Globals!ExecutionTime)), 2)
& ":"
& Right("00" & CStr(Minute(Globals!ExecutionTime)), 2)