Hi, I have a report..and I am using the Globals!ExecutionTime to show the print time. Is there a way to have the user's loca time zone printed instead of the GMT?
GetDate() will give you the current date and time and you can just use CONVERT() to grab just the time. CONVERT(varchar(10), GETDATE(), 101) AS currentdate will give you 1/31/2007
>Hi, > I have a report..and I am using the Globals!ExecutionTime to show the [quoted text clipped - 4 lines] >thanks, > Matthias