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

05 December 2013 2013-12-03 Tuesday 08:45 12:00 13:30 17:45 7:30 14:30 2013-12-04 Wednesday 09:00 12:30 13:30 17:00 7:00 21:30 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...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 ASC, AndAnotherOrderByCol ASC -- Yields /* Day ---------------- Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL query (Transact-SQL) used in an Excel file. Some of our...

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

Include a carriage return in a column headinghttps://www.joellipman.com/articles/microsoft/sql-server/include-a-carriage-return-in-a-column-heading.html

07 July 2014 Week" and instead expands to the width of the word "Academic". What I have: Academic Week Monday Tuesday Wednesday Thursday Friday ---------------- ----------- ----------- ----------- ----------- ----------- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014...

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

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

08 November 2018 value; and use 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...

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

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

17 November 2021 only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday = Collection(); c_Thursday = Collection(); c_Friday = Collection(); c_Saturday = Collection(); // // loop through Monday subform for each r_Row in...

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

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

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

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

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

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

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 happened after 8 (Monday). How? See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that...

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

Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 week 2 days 4 hours 2 seconds'); // yields "1 week ago" $v_Str = getTimeAgo('last Monday'); // yields "3 days ago" (it's Thursday) $v_Str = getTimeAgo('first day of this month'); // yields "15 days ago" (it's the 16th) The same PHP function as above but...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

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

27 September 2019 } else if(v_InputSwitch.toString().indexOf("Wednesday") > 0) { v_DayIndex = 4; } else if(v_InputSwitch.toString().indexOf("Thursday") > 0) { v_DayIndex = 5; } else if(v_InputSwitch.toString().indexOf("Friday") > 0) { v_DayIndex = 6; } // occurrence...

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