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

Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 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: *

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

14 May 2024 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
• Language: *

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

05 December 2013 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: *

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

05 December 2018 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
• Language: en-GB