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

31 January 2020 = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames = {"January","February","March","April","May","June","July","August","September","October","November","December"}; Here's the standard code you'd expect if your Fiscal year starts in January (Divide by 3 and...

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

404: Page Not Foundhttp://mail.joellipman.com/static-items/404.html

11 February 2015 possible that you have followed an out-of-date link or incorrectly typed an address. We have revamped this website as of September 2015 and tidied up some of our URLs. Some sections will have been moved about but all the content that was on the old site...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• 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 // using Analytics API v1.0 (suprisingly still works in September 2025) /* v_OwnerEmail = ""; v_WorkspaceName = "Zoho CRM Reports"; v_ViewName = "ZohoSurveys - Spider Chart"; // invalid oauth is check your TLD (eg. .com or .eu or...) v_Endpoint =...

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

MediaWiki: MySQL to extract path to imageshttp://mail.joellipman.com/articles/cms/mediawiki/mediawiki-mysql-to-extract-path-to-images.html

06 December 2011 ORDER BY img_timestamp DESC Note that I've commented out the lines which specify images modified since the 22nd of September 2011. I've left it in there for my own benefit as it's unlikely I'm asked for an entire export. Should yield something like:...

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