Advanced Search

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 0,10 is required, the following 5 results were found.

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

    HH:mm:ss"); v_ExpiryTime = "2020-03-25T21:41:07+00:00"; v_ExpiryDatePart = v_ExpiryTime.subString(0,10); v_ExpiryTimePart = v_ExpiryTime.subString(11,19); v_ExpiryTimeCheck = v_ExpiryDatePart + " " + v_ExpiryTimePart; info v_CustomTime.toTime(); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    QUOTE DATES ---------------------- m_CreateEstimate.put("date",r_QuoteDetails.get("Created_Time").subString(0,10)); if(!isnull(r_QuoteDetails.get("Valid_Till"))) { m_CreateEstimate.put("expiry_date",r_QuoteDetails.get("Valid_Till").subString(0,10)); }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  3. 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

    = r_LeadDetails.get("Created_Time"); // // convert to time datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd HH:mm:ss", v_ThisTimeZone); // // set reminder time (exactly 1 working...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    AND CONCAT('2010', '-', MONTH(NOW()), '-', DAYOFMONTH(NOW())) GROUP BY b.user_name ORDER BY COUNT(a.VisitorID) DESC LIMIT 0,10;

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  5. Creating a Top 10 chart with less codehttps://www.joellipman.com/articles/cms/website-development/php/creating-a-top-10-chart-with-less-code.html

    ten) My new method is: SELECT column1, COUNT(*) AS CountOrder FROM table1 GROUP BY column1 ORDER BY CountOrder DESC LIMIT 0,10 PHP script to loop through the results of the above query Display the value of column1 and CountOrder The old code would have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
Results 1 - 5 of 5