Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming todate is required, the following 10 results were found.

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

    { 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 Deluge
    • Language: en-GB

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

    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 Deluge
    • Language: *

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

    { 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 People
    • Language: *

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

    = 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 Projects
    • Language: *

  5. SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/component/content/article/ssrs-use-t-sql-like-with-a-parameter.html?catid=75&Itemid=165

    , 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

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

    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 Deluge
    • Language: *

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

    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 Creator
    • Language: *

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

    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 CRM
    • Language: *

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

    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 CRM
    • Language: *

  10. Set default parameter dates to start and end of monthhttps://www.joellipman.com/component/content/article/set-default-parameter-dates-to-start-and-end-of-month.html?catid=75&Itemid=165

    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: *
Results 1 - 10 of 10