Assuming datetime is required, the following 27 results were found.
-
the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and table names as per your...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
date and campus -- =============================================================================== DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId varchar(10), @weekNumber int, @siteId nvarchar(5), @baseDate datetime, @specifiedDate...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DECLARE @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) --First day to display on calendar SET @StartDate = DATEADD(DAY,-DATEPART(WEEKDAY,@StartDate)+1,@StartDate)...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to do the 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 @GivenDate = '23/03/2011'; --First slot of the day SET...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
file function getStoredCredentials($path) { $credentials = json_decode(file_get_contents($path), true); $expire_date = new DateTime(); $current_time = new DateTime(); $expire_date->setTimestamp($credentials['created']-300); $expire_date->add(new...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
= zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery = "select Start_DateTime, End_DateTime from Events where Created_By='" + v_UserID + "' and ("; v_CoqlQuery = v_CoqlQuery + "Start_DateTime>='" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
your original SQL query and save results as table t1 SELECT -- perform formatting to extract the minimum data here (eg. datetime into date, etc) * FROM [pretendDatabase].[pretendSchema].[pretendTable] t0 WHERE [pretendField]='elephantastic' -- end your...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
we were using the following MDX statement which had seconds as its smallest denominator: ="Execution Time: " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours) + " hour(s)" + " , " +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
`SessionStaff` ssf ON ssf.sessionId=s.sessionId LEFT OUTER JOIN `SessionStudent` sst ON sst.sessionId=s.sessionId WHERE s.dateTime >= '2013-02-01 00:00:00' -- Deletes all sessions dated after February 1st 2013 -- and all related records (linked by ID)...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
like: input.Audit_Change = "Title: " + input.Title; Method #1: (do not use) Previously I have tried adding a field called "DateTime form was loaded" which would have the currenttime when the form was loaded. Then I would tell Audit_Change to only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with datetime criteria: NB: You can't compare a date time value to a field that is simply of datatype: date v_PerPage = 200; v_CountCriteria =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Well I find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
if not blank) if(debugString!="") DebugLogEvent(debugString); } } } } private void DebugLogEvent(string DebugString) { DateTime now = DateTime.Now; this.ComponentMetaData.PostLogMessage(DebugLogEventName, this.ComponentMetaData.Name, DebugString, now,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ"); // value is "2020-02-10T11:49:12+0100" // yields...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want to add 10 minutes to a date/time field in ZohoCRM and wanted a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
at 7am in Los Angeles; and tell headquarters or the system calendar that the appointment is at 10am. How? So adding a datetime field and calling this one the "Customers Appointment Time" is the wrong first step. Reason being is that datetime fields hold...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
// the meeting location m_ScheduleMeeting.put("Venue","Online Meeting"); // // the start time m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // // the end time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *