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 endtime is required, the following 6 results were found.

  1. 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

    // // 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", "Billable", "Non Billable"); v_WorkNotes =...

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

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

    = v_CheckDateStart; } v_CheckDateEnd = v_LastMonthDate.addDay(v_DayIndex); if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime = v_CheckDateEnd; } } info "Start Date (Current Year): " + v_DST_StartTime.toString("EEEE, yyyy-MM-dd HH:mm"); info "End...

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

  3. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    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 @StartTime...

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

  4. 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

    v_ThisTimeZone); // // want the reminder to appear daily until 3 days after creation date (inclusive of 4th?) v_EndTime = v_TimeOffset.addBusinessDay(3).toString("yyyy-MM-dd'T'HH:mm:ss", v_ThisTimeZone); // // create the task at the same time as lead...

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

  5. Zoho Deluge: Check Time Booking Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-check-time-booking-slots.html

    bool_doubleBooked=false; for each thisRecord in allRecords { thisRecord_StartTime = thisRecord.req_StartTime ; thisRecord_EndTime = thisRecord.req_StartTime.addMinutes(req_Duration); if(v_StartDate = thisRecord_StartTime)||(v_StartDate =...

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

  6. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    help me adapt it to whatever environment people keep throwing at me. What I want: ThisDate ThisDay StartTime TimeOut TimeIn EndTime TotalTimeToday TotalTimeWeek ----------- ----------- ---------- -------- ------- -------- -------------- -------------...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
Results 1 - 6 of 6