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

27 November 2012 that we have a system holding a calendar in the following table (called "joes_weekstructure"): ID AcademicSet WeekNumber StartDate --------- ----------------- --------------- ------------------ 417 2012/2013 1 2012-07-16 418 2012/2013 2 2012-07-23 419...

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

Parameters not being used in report processinghttps://www.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 WeekNumber from the weekstructure table based on the given date SET @setId = (SELECT TOP 1 SetId FROM WEEKSTRUCTURE WHERE StartDate BETWEEN DATEADD(day, -6, @specifiedDate) AND DATEADD(day, 6, @specifiedDate)) SET @weekNumber = (SELECT TOP 1 WeekNumber...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

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

11 October 2011 same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /* Day...

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

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 www.simple-talk.com/sql/reporting-services/ten-common-sql-server-reporting-services-challenges-and-solutions/ DECLARE @StartDate DATETIME, @EndDate DATETIME --First day of current month SET @StartDate = DATEADD(s,0,DATEADD(mm,...

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

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

15 April 2011 week numbers. So I can't use the built-in functions. The current structure looks similar to this: ID SetID WeekNumber StartDate --------- ---------------- ---------------------- ---------------------------- 1 2011/2012 1 2011-07-18 00:00:00... 52...

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

AHK Countdown Tooltiphttps://www.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 SetTimer, UpdateMessage, Off Sleep, 12000 GoSub, GoExit } ThisMessageIndex++ Return DateDiff( startdate, enddate, units="d" ) { If units NOT IN s,sec,second,seconds,m,min,minute,minutes,h,hour,hours,d,day,days units := "d" ; default to days Else...

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

Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-radio-group-into-calendar-carousel.html

09 March 2022 enter into the Selected_Date field: // creating map for offset (determine which CSS box was selected) m_Offset = Map(); v_StartDate = input.Starting_Date; v_RefIndex = 0; for each v_Offset in {1,2,3,4,5,6,7} { v_RefIndex = v_Offset - 1;...

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

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

05 December 2018 = thisRecord.req_StartTime ; thisRecord_EndTime = thisRecord.req_StartTime.addMinutes(req_Duration); if(v_StartDate = thisRecord_StartTime)||(v_StartDate = thisRecord_EndTime) { doubleBooked=true; } }

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

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 + "-" + SUBSTRING(This_Date,4,2) + "-" + SUBSTRING(This_Date,1,2) + " 00:00:00") -- Explicit: Assuming [StartDate]="21032012" (DDMMYYYY) (DT_DATE)(SUBSTRING((DT_STR,8,1252)StartDate,1,2) + "/" + SUBSTRING((DT_STR,8,1252)StartDate,3,2) + "/" +...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

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 (in my case the UNTIL given a CRM/Atom date time format). m_Recurrer.put("RRULE","FREQ=DAILY;INTERVAL=1;DTSTART=" + v_StartDate + ";UNTIL=" + v_EndDate); This isn't an error but just here to remind me how to repeat the task. Unnecessary here as the...

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