Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

31 January 2020 the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm showing this in Zoho Deluge but the logic can be adapted to other code. You will need this...

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

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 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, and we want to work out profits in January, we're including the credit notes that were...

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

Lazy stats: Yootheme / Gavick Pro / Rocket Theme Comparisonhttps://joellipman.com/articles/cms/joomla/lazy-stats-yootheme-and-gavick-pro.html

08 April 2010 224 €* ($300) Support Thu 22:00 April 2010 Established YooTheme Forum Video Tutorials Twitter ? guests 6 members online January 2007 Gavick Pro Forum Twitter 456 guests 49 members online May 2007 RocketTheme Forum Twitter 8282 guests 236 members online...

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

Inserting incremental weeks in MySQLhttps://joellipman.com/articles/database/mysql/inserting-incremental-weeks-in-mysql.html

15 April 2011 goes in with a normal calendar date and returns an academic week number and the week commencing date. Problem? The 1st of January 2010 was a Friday. The 1st of January 2011 was a Saturday. The developer felt that as long as you adjust the script each...

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

Proposed Budget i3 PC under £200https://joellipman.com/hardware/proposed-budget-i3-pc-under-200.html

26 January 2013 we need something that flows as smooth as any other Microsoft product with Windows 7 as its Operating System: Proposed for January 2013 (5 suppliers) Processor Intel Core i3 3220 Dual Core CPU ( 3.30GHz, Socket 1155, 3MB Cache, Ivy Bridge, 55W, Intel HD...

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

htaccess Rewrites SEF URL and submits to PHPhttps://joellipman.com/articles/web-development/php/htaccess-rewrites-sef-url-and-submits-to-php.html

05 September 2013 (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // sends index.php?myFolder=blog/videos/2010/january&myFiles=21 Which, hopefully, the PHP file will handle as: var...

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

MS-DOS: Copy folders without overwriting fileshttps://joellipman.com/articles/automation/ms-dos/ms-dos-copy-folders-without-overwriting-files.html

23 February 2014 command prompt (Start > Run... > CMD > ok) Type the following: ECHO N | XCOPY /E c:\Sourcepath\*.* c:\Destpath\*.* -- since January 1st 2010 XCOPY /E /D:01-01-2010 c:\Sourcepath\*.* c:\Destpath\*.* // D: is in mm-dd-yyyy format This will copy any files...

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

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 You should check this page from time to time to ensure that you are happy with any changes. This policy is effective from January 1st, 2025. What we collect We may collect the following information: Name and job title Contact information including email...

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

Privacy Policyhttps://joellipman.com/static-items/privacy-policy.html

30 May 2009 check this page from time to time to ensure that you are happy with any changes. This policy is effective from the 1st of January 2009. What we collect We may collect the following information: name and job title contact information including email...

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

Excel PivotTable Filter List Orderinghttps://joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 "Move to Report Filter") Advanced Sorting So the above works which is great but what if you have a list of month names? January comes before February but not alphabetically, so let's do this as an example: Move the field from "Report Filter" to "Row...

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