MySQL day of week ending on Fridayhttps://joellipman.com/articles/database/mysql/mysql-day-of-week-ending-on-friday.html

26 April 2012 an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which...

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

Zoho Creator: Copy Subform to other Subformshttps://joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 it to the remaining working days. How? So I have a form with 6 subforms which list staff/employee shifts from Monday to Saturday. The form I have looks something like the following: and displays as something like this: The code I create a workflow that...

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

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

08 November 2018 this in the second array as follows: // lists Day_Names = List:String({"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"}); Day_Abbreviations = List:String({"Mon","Tue","Wed","Thu","Fri","Sat","Sun"}); // get date field day...

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

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

05 December 2013 2013-12-05 Thursday 10:00 12:15 12:45 17:15 7:45 29:15 2013-12-06 Friday 07:00 12:00 13:00 16:30 8:30 37:45 2013-12-07 Saturday - - - - 0:00 37:45 2013-12-08 Sunday 03:00 04:00 - - 4:00 41:45 Some Requirements; StartTime will be the earliest someone...

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

Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

02 November 2021 over the next few days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use the .addDay(), check none of these are a...

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

ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

28 March 2023 Yields something like { "business_hours": { "business_days": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ], "custom_timing": [ { "days": "Monday", "business_timing": [ "7:00", "18:00" ] }, { "days": "Thursday",...

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

Split a row into multiple rows based on a column valuehttps://joellipman.com/articles/database/t-sql/split-a-row-into-multiple-rows-based-on-a-column-value.html

23 August 2013 1.00 2000-02-20 003 1.00 1999-02-25 003 1.00 1999-02-26 -- note the dates increment and do not account for days off (eg. Saturday / Sunday) How? Adapted from a forum topic: SQLTeam Forums First of all, we want the rows to multiply based on the value of...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 week number and the week commencing date. Problem? The 1st of January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each year you could make the system last another year. Shame he...

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

Generate Academic Calendar using MySQLhttps://joellipman.com/articles/database/mysql/generate-academic-calendar-using-mysql.html

27 November 2012 DATEADD(d, 5, calendar.StartDate)), 1, 3) + '-' + CAST(DATEPART(yyyy, DATEADD(d, 5, calendar.StartDate)) AS VARCHAR(4)) AS Saturday, CAST(DATEPART(dd, DATEADD(d, 6, calendar.StartDate)) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, DATEADD(d, 6,...

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