i need ssrs expressions iam new into designing part i want to display date along with time and sec is displayed in one line ,no need am/ pm 11/02/2016 11:13:15 can any one guide me what is the expression in visual studio

Finance and Operations/AX Developer Forum
1

i need ssrs expressions iam new into designing part

i want to display date along with time and sec is displayed in one line ,no need am/ pm 11/02/2016 11:13:15

can any one guide me what is the expression in visual studio

2

Hello sridardax,

this is what I use and it should roughly be what you are looking for:

=Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(
Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value,
System.DateTime.UtcNow,
“d”,
Parameters!AX_RenderingCulture.Value)
& " " &
Microsoft.Dynamics.Framework.Reports.DataMethodUtility.ConvertUtcToAxUserTimeZoneForUser(
Parameters!AX_CompanyName.Value,
Parameters!AX_UserContext.Value,
System.DateTime.UtcNow,
“t”,
Parameters!AX_RenderingCulture.Value)

The format specifier “t” will only display hours and minutes, not seconds, but you should be able to make it work by modifying this parameter.
Let me know if it worked for you.

Edit: I didn’t think it through, you can just use standard date formatting notation. So in your case, instead of “t”, “H:mm:ss” should give the correct result.

3

=Format( Time expression here, “MM/dd/yyyy hh:mm::ss”) , the key is to use “Format()” function.