Assuming monday is required, the following 18 results were found.
-
FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /* Day ---------------- Monday Monday Monday Tuesday Tuesday Wednesday Thursday Thursday Thursday Thursday Friday Friday */ This is actually part of a SQL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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 month is before the current date, then set it to the last...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday but in the United Kingdom, the week generally starts on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
TotalTimeWeek ----------- ----------- ---------- -------- ------- -------- -------------- ------------- 2013-12-02 Monday 09:00 12:00 13:00 17:00 7:00 7:00 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
expand to the width of "Academic Week" and instead expands to the width of the word "Academic". What I have: Academic Week Monday Tuesday Wednesday Thursday Friday ---------------- ----------- ----------- ----------- ----------- ----------- 1...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main Office 09:00 17:00 Notes Monday 03/10/2011 Boss' Office 09:00 17:00 Notes Monday 03/10/2011 Stationary Cupboard...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 of the day (eg. "Mon"). My_Date = today; Day_Name =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
GET connection: "mycrmconnection" ]; info r_OrgDetails; Yields something like { "business_hours": { "business_days": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ], "custom_timing": [ { "days": "Monday", "business_timing": [...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
(format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month (dd) 4 %j day of year, zero padded 001-366 %u day of week starting...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The solution below is for the opposite, where the week starts on the previous Saturday and...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Monday', ( SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(s.EstimateTimeFinish)-TIME_TO_SEC(s.DateTimeCreated))) AS SecondsElapsed FROM...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
v_Tomorrow.toString("EEEE dd-MMM-yy"); info v_NextDay.toString("EEEE dd-MMM-yy"); // // yields: // Saturday 30-Oct-21 // Monday 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
{ // // get user id v_UserID = r_User.get("id"); // // startofweek is a sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd"); // // build up COQL Query v_CoqlQuery =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Jun 15, 2009 =Format(Fields!myDateTime.Value, "Short Date")... 6/15/2009 =Format(Fields!myDateTime.Value, "Long Date")... Monday, June 15, 2009 =Format(Fields!myDateTime.Value, "ddd dd/MM/yyyy")... Mon 04/04/2011 European and Now: The above is about...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
t.TeamName AS Team, CONCAT(u.Firstname, ' ', u.Lastname) AS StaffName, CASE 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'...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
+ '-' + SUBSTRING(DATENAME(mm, calendar.StartDate), 1, 3) + '-' + CAST(DATEPART(yyyy, calendar.StartDate) AS VARCHAR(4)) AS Monday, CAST(DATEPART(dd, DATEADD(d, 1, calendar.StartDate)) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, DATEADD(d, 1,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB