Monday, April 10, 2023

Print current date in report using x++

 Print the current date in the report using x++.


Use any function to print the date:

=formatdatetime(today)


=FORMAT(Cdate(today), "dd-MM-yyyy")


=Report Generation Date: " & FORMAT(Cdate(today), "dd-MM-yyyy")


=Format(Now(), "dd/MM/yyyy hh:mm tt")


="Report generation date:  " & Format(Globals!ExecutionTime,"dd/MM/yyyy  h:mm:ss tt" )


="Report Generation Date: " & Today()

 
=Format(today(), "dd/MM/yyyy")
 
 
=Globals!ExecutionTime


or

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

Print user details:
 =User!UserID
XUserInfo::find(false, curUserId()).name;   


Keep daxing!!

No comments:

Post a Comment