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

16 May 2019 used this for password change reminders but on this occasion for a listing of reviews laid out as per the following screenshot:

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

MS Excel - Sort pivottable column headings by datehttps://www.joellipman.com/component/content/article/sort-pivottable-column-headings-by-date.html?catid=110&Itemid=165

12 April 2013 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 Microsoft thinks Wednesdays come...

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

Excel: Find values in one column that are not in anotherhttps://www.joellipman.com/component/content/article/excel-find-values-in-one-column-that-are-not-in-another.html?catid=110&Itemid=165

06 March 2014 -- Returns #N/A for a value which is NOT in column A. Drag the formula in B2 down all the list as per the following screenshot. A value equal to "#N/A" means the value was NOT found in column A. Method #2 Be careful with this one because if you copy the...

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

Excel - Check a column for values found in another columnhttps://www.joellipman.com/component/content/article/excel-check-a-column-for-values-found-in-another-column.html?catid=110&Itemid=165

14 February 2019 purposes): If you understand this article, you may have noticed that the range of words to find from Sheet2 in this screenshot are from the cells B1:B4... This is because I already had values in A1:A4 and wanted to test against a set of different words.

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

Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

20 March 2019 SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Or via cPanel the following screenshot when adding a user to a database: Method #1: The following command on a cron job: // not recommended: /usr/bin/mysqldump -u...

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

Docman - Uploaded a document and can't see ithttps://www.joellipman.com/articles/cms/joomla/docman-uploaded-a-document-and-cant-see-it.html

29 June 2009 showing: Check that they're in the right section and category Check that they have been approved and published This is a screenshot of two uploaded documents:

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

SSRS Repeat Headers in PDF Reporthttps://www.joellipman.com/component/content/article/ssrs-repeat-headers-in-pdf-report.html?catid=75&Itemid=165

26 October 2011 - PDF generated to a Windows File Share The Fix Click on the down arrow icon near the "Column Groups" panel (see below screenshot). Click on the "static" row that is the header of the tablix (the data of the tablix is "details"). Set "FixedData" to...

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

Leap Motion and AR Dronehttps://www.joellipman.com/component/content/article/leap-motion-and-ar-drone.html?catid=113&Itemid=165

17 May 2013 The following videos were shown to me by a colleague at work. I was so impressed I just had to post them. So here's a screenshot, read more if you want the videos: So Leap in Motion AR Drone: {youtube}ZOdxlrQj_ZU{/youtube} Just as amazing but old news:...

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