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

05 September 2011 on it and select "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...

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

Cheat Sheet for mySQL vs t-SQLhttps://joellipman.com/articles/database/cheat-sheet-for-mysql-vs-t-sql.html

31 January 2013 Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now()) DATENAME(mm, getdate()) Month Number MONTH(now()) DATEPART(mm, getdate()) European Date (dd/mm/yyyy)...

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

SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 maybe all the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the...

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

Zoho Deluge: Generate and Send a CSV via Emailhttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me every month"... How? Rather than just babble on about it, here's the code, replace what you need just noting that I'm enclosing each...

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

Free Translator API using Googlehttps://joellipman.com/articles/google/free-translator-api-using-google.html

08 January 2013 working with your website. Why? At time of print, Google now charge for every 2,000,000 characters (2 million) every month. Microsoft's Bing has added itself to the fray pretending to offer free services but in the small print, you will find they too...

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

Joes Google Map for Joomla (JGM)https://joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=40

13 April 2015 a module using the Google Maps API v3 styling features which includes Points of Interest (POI). Considering I spent a good month styling Google Maps for Android OS on a mobile app, having access to the Google Map API v3 in JavaScript is a doddle... And...

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

Zoho Deluge - Get English Ordinalhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-english-ordinal.html

08 November 2018 #1: Using a list/array, I'm going to check the date against the 3 exceptions to this rule (11th, 12th and 13th of each month): // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English Ordinal...

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

Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

02 February 2019 for a user. Again this script doesn't need the client libraries, composer, vendor, etc. Why? This took me the best part of a month to get working. It is taken from Google's documentation as well as other forums and websites that try to explain it. Do...

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