... as per the format on the CRM record)
v_StartDateFormatted = v_LocalStartDate.toJSON().slice(0, 10);
// add this as one argument in the JSON
json_Arg.Start_Date = v_StartDateFormatted;
...
... below... hopefully it will be quicker next time now that I noted it all down.
The SQL Script:
DECLARE
@StartTime datetime,
@EndTime datetime,
@GivenDate datetime;
SET DATEFORMAT dmy;
SET ...
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as:
=FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate)
The ...
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.