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

16 May 2019 Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...

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

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

22 July 2024 then this is obvious; if you haven't then it may be difficult to work this out. Put simply, "Closed" are events in the past and "Open" are events in the future. The "is_open" in tasks is misleading and cannot be used in the request for events. There are...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 own internet connection. Support: Apologies for not having a discussion forum available but this has not helped me in the past and I have found it easier to answer comments on the website (rather than managing moderators, posts/topics, and opening any...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Forum Ruleshttps://joellipman.com/static-items/forum-rules.html

31 May 2009 on TEU. This is because this information then becomes accessible to anyone. No Threatening to Leave the Board - Due to past experiences on the board, I have had to add this rule. You may not make posts threatening to leave the board. This causes flaming...

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

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

25 September 2009 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. Obviously something is...

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

Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 it has saved me so much time! What does this do? After many tweaks and corrections having upgraded multiple sites in the past few years with this script, the version below migrates the following: Articles Banners Categories & Sections Menus * NEW...

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

SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 below will also let you do this (requirements: common sense or the IQ of a duck). It's what I've been searching for for the past hour and although you may think I'm just adding to the cyberspace pile of useless info, at least I'm not just copying and...

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

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

06 April 2011 00:30:00 - 2011-03-08 23:30:00 = -23.00 This is great for everything during that date as long as the "To Date" never goes past midnight into the next day... But what system doesn't do this (no Microsoft jokes please)? The Solution Eureka! Or duh! for...

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

MySQL last year week month day trend periodshttps://joellipman.com/articles/database/mysql/mysql-last-year-week-month-day-trend.html

31 October 2011 a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick...

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

Upgrading a Joomla 1.5 module to Joomla 2.5https://joellipman.com/articles/cms/joomla/upgrade-a-joomla-1-5-module-to-joomla-1-6.html

11 February 2011 and can quickly update any extensions designed for Joomla 1.5.x and make these compatible with Joomla 2.5.x websites. In the past, I have only ever changed the words to but for more stability, there are a few more tweaks to do. How? For demo purposes we...

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

Improve Default Joomla Search https://joellipman.com/articles/cms/joomla/improve-default-joomla-search-heuristics.html

07 May 2013 Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: If this is a search system for a technical database, and there is one...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 reviewed prior to being added to the database but each country's aviation authority has been added. Earthquake Feed for the past day: earthquake.usgs.gov/earthquakes/feed/geojsonp/2.5/day Flight Regulations API v0.9 version 0.9: Last Modified 2014-11-05...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

ZohoCRM: Process all records of a modulehttps://joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 and mark it so that the process doesn't repeat on records that have already been checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me....

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 kind of guy. My skillset is really around software (see my other articles) and I've been using Mac alongside my PCs for the past 7 years. My MacBook is from 2015 and still runs everything from MacOSX to Final Cut Pro (latest version 2022) and I don't...

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

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 called: Number of Candidates This Graduation Year Number of Candidates Next Graduation Year Candidates Graduated in the Past Candidates Graduating in the Future Total Number of Candidates I'll flesh this out some other time but here's the code I used:...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 we want to calculate credit notes issued in a particular month rather than the one-to-one with an invoice as profits in the past would change. So this table is created so that if a credit note was issued in January for an invoice issued prior to this,...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 //info r_Create; } } } } For historical records The below snippet is what I used to bring all the past records into the custom module. The client would be able to determine what jobs have started/expired based on their Candidate reference and Vacancy...

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