... start in CRM format
v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset;
//
// set system/application date time start in US format
v_CustomerAppointmentDateTimeStart ...
... work on your reporting server as well. I'm using the database "ReportServer".
select * from
(
SELECT TOP 1
c.[Name] AS [ReportName]
, e.[ReportID] AS [ReportID]
, e.[TimeStart] AS [TimeStamp]
, ...
... option 2.
Check this result - Possibly from the Reporting Server ExecutionLog?
Using the ReportServer Execution Logs, we can determine if this is correct
SELECT TOP 1
c.Name,
e.TimeStart, ...
... a report as a user.
Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer.
Parameters ntext NULL Parameters and the values they were submitted with.
TimeStart ...
...
Catalog.Name AS ReportName,
DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun,
DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun,
DATEPART(year, ExecutionLogStorage.TimeStart) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.