Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://joellipman.com/articles/crm/zoho/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

27 September 2019 { for each v_MyDay in {1,2,3,4,5,6,7,8} { v_NextMonthDateFirst = v_NextMonthDateFirst.toDate(); v_NextMonthMonday = v_NextMonthDateFirst.addDay(v_MyDay); if(v_NextMonthMonday.getDayOfWeek()==2) { break; } } input.Next_Switch_Date =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

01 September 2021 will usually handle the date better. Consider the following: v_TestDate = "07/01/1975"; info v_TestDate; info v_TestDate.toDate(); info v_TestDate.toString("E, d MMM yyyy"); info "*********************"; // // regex change dd/MM/yyyy to yyyy-MM-dd...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 { v_ThisStatus = r_TimeOff.get("ApprovalStatus"); v_ThisFrom = r_TimeOff.get("From").toDate(); v_ThisTill = r_TimeOff.get("To").toDate(); v_ClashOrNot = "NO Clash with "; if(v_ThisStatus!="Cancelled") { if(v_CompareDateFrom = v_ThisFrom ||...

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

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

30 April 2021 = v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm);...

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

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 , rb.[ContactName] , rb.[Room] , rb.[BookingNotes] FROM roombookings rb WHERE rb.[GivenDate] BETWEEN @GivenDate AND @ToDate AND rb.[ContactName] LIKE '%@GivenName%' -- WARNING: 0 matching rows This returns nothing. Took me a while to figure why but it's...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Set default parameter dates to start and end of monthhttps://joellipman.com/articles/microsoft/ssrs/set-default-parameter-dates-to-start-and-end-of-month.html

05 April 2011 must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Zoho Deluge - Get Full Day Namehttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-full-day-name.html

08 November 2018 the inevitable single line: Day_Name = ",Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday".toList(",").get(My_Date.toDate().getDayOfWeek());

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

Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 v_RefIndex = 0; for each v_Offset in {1,2,3,4,5,6,7} { v_RefIndex = v_Offset - 1; m_Offset.put(v_StartDate.toDate().addDay(v_RefIndex).toString("d"),v_Offset); } input.Selected_Value = input.Calendar_Day_Select; v_DateOffset =...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 m_NewTask.put("Subject","Follow Up Non Converted Lead"); m_NewTask.put("Due_Date",v_EndTime.toDate()); m_NewTask.put("Status","Not Started"); // // configure reminder on task to run daily at the same time as creation time m_Reminder = Map();...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 v_SignDate = m_SignDocument.get("requests").get("action_time"); v_SignDate = v_SignDate.toDate("yyyy-MM-dd"); r_Update =...

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