Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming date is required, and interval is required, the following 9 results were found.

  1. Generate a Timesheet in MySQL https://www.joellipman.com/articles/else/database/mysql/generate-a-timesheet-in-mysql.html

    What? This article is to remind me how to create a blank weekly timesheet which reads the duration of events from a database and auto-completes your timesheet. Why? I'm being tasked to work with EPM (Microsoft Enterprise Project Management) more and...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *
  2. Generate Academic Calendar using MySQLhttps://www.joellipman.com/articles/else/database/mysql/generate-academic-calendar-using-mysql.html

    What? We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  3. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    What? Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  4. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    What? An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Cheat Sheet for mySQL vs t-SQLhttps://www.joellipman.com/articles/else/database/cheat-sheet-for-mysql-vs-t-sql.html

    Seconds to Time SEC_TO_TIME( seconds ) CONVERT(varchar, DATEADD(ms, seconds * 1000, 0), 114) Add/Subtract Date DATE_ADD(date,INTERVAL number datepart) DATE_SUB(date,INTERVAL number datepart) DATEADD(datepart, number, date) DATESUB(datepart, number,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: *
  6. MySQL last year week month day trend periodshttps://www.joellipman.com/articles/else/database/mysql/mysql-last-year-week-month-day-trend.html

    Why? I recently made 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  7. Inserting incremental weeks in MySQLhttps://www.joellipman.com/articles/else/database/mysql/inserting-incremental-weeks-in-mysql.html

    Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  8. Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    The Issue People have reported that although they have manually set the date/time on their computer, this gets changed by the windows time server (time.windows.com) when connected to the Internet and for some reason it doesn't display the right...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  9. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    What? This is an article to document how to use Zoho Deluge to download a file that was uploaded into a Zoho Creator form and then to attach it to a Sales Order in Zoho Books. Why? Because it took me so long to find out how to do this even after reading...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
Results 1 - 9 of 9