Unix Date Format Specifiershttp://mail.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 %C cc century 00–99 Date %D mm/dd/yy 07/4/11 %x locale's date representation (mm/dd/yy) 07/4/2011 %F %Y-%m-%d 2011-07-4 Hours %l (Lowercase L) hour (12 hour clock) 1 %I (Uppercase I) hour (12 hour clock) zero padded 01 %k hour (24 hour clock) 13 %H hour...

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

Zoho Projects: Get All Eventshttp://mail.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 = l_ThisDateTimeEventParts.get(1).toList(":"); v_ThisDateEvent_Minute = l_ThisTimeEventParts.get(1); v_ThisDateEvent_Hour = l_ThisTimeEventParts.get(0); // // convert 12-hour to 24-hour v_ThisDateEvent_Hour = if(l_ThisDateTimeEventParts.get(2)=="PM",...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 I tried and I spent a few hours searching the net for a solution which displays the hours in the top columns, and undefined number of rooms in the rows. No all I was looking for was a calendar showing 1 day with the hours on the top. Working hours only...

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

Difference between two dates - the midnight hourhttp://mail.joellipman.com/articles/web-development/difference-between-two-dates-the-midnight-hour.html

06 April 2011 this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

AHK Countdown Tooltiphttp://mail.joellipman.com/articles/automation/autohotkey/ahk-countdown-tooltip.html

17 July 2014 ; TOTALS ThisManySeconds:=DateDiff( A_Now, FinalDate, "s" ) ThisManyMinutes:=Floor(ThisManySeconds/60) ThisManyHours:=Floor(ThisManySeconds/3600) ThisManyDays:=Floor(ThisManySeconds/86400) ThisManyWeeks:=Floor(ThisManySeconds/604800)...

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

Project Plan for Freelance Websitehttp://mail.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 they retain overall control of the company) Who will be working on this project? (supply contact details) Rates (usually £9/hour for non-e-commerce sites or £15/hour for e-commerce) Similar looking websites where layouts/colour schemes can be adapted...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

How to Display Report Execution Time in SSRS (milliseconds)http://mail.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 had seconds as its smallest denominator: ="Execution Time: " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours) + " hour(s)" + " , " + CStr(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes) + " minute(s)" + ", " +...

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

Zoho Deluge: Loop through 30 Minute Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

30 November 2018 I want to modify a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found and...

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

Convert Decimal (Person Days) to Time in Excelhttp://mail.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 would appear can book whatever time, eg. 5mins). 30 minutes for us translates to 0.07 in person days (a person day being 7 hours and 24 minutes or 26640 seconds). How? The answer was always going to be a convoluted formula just to convert it into...

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

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 I will configure my server to receive requests for those domains (along with webspace and emails). Please wait up to 3 hours for these changes to cascade across my servers (average wait is 1 hour). JoelLipman.Com will develop the startup site using an...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)http://mail.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

16 December 2021 for outbound and inbound but local to the customer and we want to remind our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will need to follow these steps to get the credentials: Login...

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

SQL Queries for Statisticshttp://mail.joellipman.com/articles/database/mysql/sql-queries-for-statistics.html

13 December 2010 by month with on-peak/off-peak. SELECT CONCAT(MONTHNAME(a.DateTimeStamp), ' ', YEAR(a.DateTimeStamp)) Month, SUM(IF((HOUR(a.DateTimeStamp) BETWEEN 8 AND 18), 1, 0)) 'Worktime', SUM(IF((HOUR(a.DateTimeStamp) BETWEEN 8 AND 18), 0, 1)) 'Out-of-Hours',...

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

Checklist for the local computer repairshttp://mail.joellipman.com/hardware/checklist-for-the-local-computer-repairs.html

28 April 2011 RAM (to charge for) Extra Cables (again to charge for) Service: Software installs at flat price Website development per hourly rate Computer repair per hourly rate "I always had work order forms in duplicate. Right above the signature line was a BIG...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

MySQL: Display Users and Duration in Matrix Timesheethttp://mail.joellipman.com/articles/database/mysql/mysql-display-users-and-duration-in-matrix-timesheet.html

27 April 2012 03:00 03:30 00:00 00:00 00:00 23:00 Method 1. Generate query to list all valid users 2. Generate query which will total hours per week per user 3. Combine in a loop to run query against each user. Post-Notes (Update 2012) The performance of the previous...

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

Joel's Reference to MidJourney v4 Promptshttp://mail.joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

11 February 2023 Times"} in the year «Year» 60s 90s Autumn during the Dark Ages at Dawn at Dusk in the Evening Futuristic during Golden Hour Historical during the Middle Ages at Midday at Midnight in the Morning Neolithic Post-Apocalyptic Prehistoric during the...

• Type: Article
• Author: Joel Lipman
• Category: Graphic Design
• Language: *

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 I found I need to edit the setup of the sync every time a new survey is added... but at least it lets me synchronize every hour. Then I'll write the SQL queries to get the individual responses into a table with labels and columns that can help me group...

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

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 after that every page load is a few hundred to few thousand queries (per page). The webserver limits me to 50,000 queries an hour and I am blowing past that quickly with just 1 person (me!) on the site so they just refuse the connnection after a while....

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

Installing phpBB3 for Joomla with a RocketTheme templatehttp://mail.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 take just a few minutes..." I've written this because I spent all night on setting up a "quick" demo resulting in a quick 1 hour nap before having to go to my day job... It sounds straight forward because both phpBB3 and RocketTheme talk about how to...

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

Is it a scam? Gumtree.com's warning signshttp://mail.joellipman.com/hardware/is-it-a-scam-gumtreecoms-warning-signs.html

12 October 2010 schemes which require you to recruit other members to get paid. For example, an ad might say that you can make £100 an hour by stuffing envelopes. But to make that money, you need to sell the system to others. For these reasons, we typically don't...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Formatting a date in an MDX queryhttp://mail.joellipman.com/articles/database/t-sql/formatting-a-date-in-an-mdx-query.html

11 January 2011 Suffix. I haven't seen this anywhere in Google, I thought I could use SWITCH to do this in an MDX query but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query: CASE...

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