Search - Joel Lipman .Com

1. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; What? An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...; Created on 27 September 2019
2. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... starts at 7, followed by 1 for Monday, 2 for Tuesday, and so on... How? The logic behind this would be to take the date of the order, check if the order date is a Sunday, subtract a day, and return ...; Created on 06 July 2023
3. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... "business_hours": { "business_days": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ], "custom_timing": [ { "days" ...; Created on 28 March 2023
4. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... if I click on Tuesday10March, this code will match "10" to the map and determine what index or offset this is from the starting date, which is "2". It can then determine which CSS element to highlight ...; Created on 09 March 2022
5. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... runs the following deluge script: // only run if true if(input.Copy_Monday_to_the_Other_Days) { // init c_Tuesday = Collection(); c_Wednesday = Collection(); c_Thursday = Collection(); ...; Created on 17 November 2021
6. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... 01-Nov-21 // Tuesday 02-Nov-21 Note that Sunday is day 1 of the week. Saturday is day 7 of the week. Here's the English ordinal bit I used: m_Ordinals = ; v_Day3_Ordinal = ifnull(m_Ordinals.get(v_NextDay.toString("d").toLong()),"th"); ...; Created on 02 November 2021
7. Zoho Deluge - Get Full Day Name: / Zoho /; What? This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters ...; Created on 08 November 2018
8. Zoho Deluge - Get English Ordinal: / Zoho /; What? This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November ...; Created on 08 November 2018
9. Include a carriage return in a column heading: / SQL Server /; ... to the width of the word "Academic". What I have: Academic Week Monday Tuesday Wednesday Thursday Friday ---------------- ----------- ----------- ----------- ----------- ----------- 1 ...; Created on 07 July 2014
10. Generate a Timesheet in MySQL: / MySQL /; ... TotalTimeWeek ----------- ----------- ---------- -------- ------- -------- -------------- ------------- 2013-12-02 Monday 09:00 12:00 13:00 17:00 7:00 7:00 2013-12-03 Tuesday ...; Created on 05 December 2013
11. MS Excel - Sort pivottable column headings by date: / Excel /; ... 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 ...; Created on 12 April 2013
12. Generate Academic Calendar using MySQL: / MySQL /; ... 1, 3) + '-' + CAST(DATEPART(yyyy, DATEADD(d, 1, calendar.StartDate)) AS VARCHAR(4)) AS Tuesday, CAST(DATEPART(dd, DATEADD(d, 2, calendar.StartDate)) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, DATEADD(d, ...; Created on 27 November 2012
13. MySQL: Display Users and Duration in Matrix Timesheet: / MySQL /; ... - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Tuesday', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed FROM ...; Created on 27 April 2012
14. Reminder on SSRS row separator: / SQL Server Reporting Services /; ... Office 09:00 17:00 Notes Monday 03/10/2011 Boss' Office 09:00 17:00 Notes Monday 03/10/2011 Stationary Cupboard 09:00 17:00 Notes Tuesday ...; Created on 26 October 2011
15. T-SQL Record Separator: / Transact-SQL /; ... ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /* Day ---------------- Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ ...; Created on 11 October 2011
16. MySQL parameters in Excel 2007 PivotTables: / MySQL /; ... WEEKDAY(s.DateTimeCreated) WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday' WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday' WHEN 5 THEN 'Saturday' ELSE 'Sunday' END AS ActivityDay, DATE(s.DateTimeCreated) ...; Created on 24 August 2011
17. Inserting incremental weeks in MySQL: / MySQL /; ... to adjust this twice a year. Complicated Facility works like this, ask it what date it is on Tuesday in Week 52 of the Academic year 2011/2012... It tells you 2012-07-10. Ask it what date it is ...; Created on 15 April 2011
18. T-SQL DateTimestamps: / Transact-SQL /; My setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), ...; Created on 23 March 2011