Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 doesn't seem to check if daylight savings is in effect): Example of taking a CRM date-time value (expiryTime) and appending toTime() prematurely - DO NOT USE v_CustomTime = "2020-03-25 20:41:07".toTime().toString("yyyy-MM-dd HH:mm:ss"); v_ExpiryTime =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

07 December 2021 March at 2:00 DST End Ends First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-03-08 02:00:00"); // // Ends First Sunday in November at 2:00 v_LastMonthDate =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 in hourList { timeSlotStr = timeSlot.toString(); if(timeSlotStr.length() zoho.currenttime && v_CheckTime1b >= v_OpeningTime.toTime() && v_CheckTime1b...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

30 April 2021 v_IssueID = ifnull(input.ZohoProject_Issue,0); // // get data from form v_StartTime = ifnull(input.Start_Time.toTime(),zoho.currenttime); v_EndTime = ifnull(input.End_Time.toTime(),zoho.currenttime.addHour(1)); v_Billable = if(input.Billing == "Paid",...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

04 May 2020 its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex = v_XeroTime.indexOf("(")+1; v_EndIndex =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator/Deluge: Calculating with Timezone Offsethttps://www.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 v_AppointmentDuration = 30; // // get customer's requested time v_CustomersRequestedTime = input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 ", "0") + ":00"; // row_Shift = Staff.Usual_Shift(); row_Shift.Day = v_WorkDay; row_Shift.Start_Time = v_StartTime.toTime(); row_Shift.End_Time = v_FinishTime.toTime(); c_UsualShift.insert(row_Shift); } c_Employee.Usual_Shift.insert(c_UsualShift); info...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Push a value to a datetime field in CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-a-value-to-a-datetime-field-in-crm.html

10 September 2021 something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subString(0,3) + ":" +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 ") + "12:00:00"; // // convert to seconds v_NowEpoch = v_NowTime.toLong(); v_NextEpoch = v_NextTime.toTime().toLong(); // // calculate seconds in between v_UnixSeconds = v_NextEpoch - v_NowEpoch; // // determine days v_Days = floor(v_UnixSeconds / 1000...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

11 November 2021 + " " + v_LeadCreatedTime; // // add 10 minutes to it and put in CRM format v_LeadCreatedTime = v_LeadCreatedDateTime.toTime().addMinutes(10).toString("yyyy-MM-dd'T'HH:mm:ss"); // // get the timezone in use v_ThisTimeZone =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *