T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How? So where does the 'B110' string come from, well from one of our...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 has occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 The Issue If you've ever made PHP scripts to process data within a LAMP environment (Linux, Apache, MySQL, PHP) then this happens a lot. In the following example, our HTML form will allow the user to specify a date (so excludes hours, minutes and...

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

Zoho CRM: Change System Field Lengthhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-change-system-field-length.html

19 June 2023 How? This is a bit of a hack and most likely not recommended... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use...

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

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

14 March 2013 IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The...

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

Convert Decimal (Person Days) to Time in Excelhttps://www.joellipman.com/articles/microsoft/excel/convert-decimal-person-days-to-time-in-excel.html

13 February 2013 0.04166667 =(ROUND(B5/0.07, 0)*0.5)/24 -- now format to [h]:mm:ss -- yields 1:00:00 Note that the first formula is converting person days into minutes and then dividing by 1440 (resulting in the decimal number: 0.04166667 - 1 hour of a 24 hour slot or...

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

Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

09 March 2020 A quick article on converting a Map (associative array with keys and values) into a URL string to pass as URL parameters. How? Let's first define a map: m_Payload = Map(); m_Payload.put("client_id","my-unique-client-id");...

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

SSRS Display question mark when date is blankhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data...

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

Convert to Proper Case in T-SQLhttps://www.joellipman.com/articles/database/t-sql/convert-to-proper-case-in-t-sql.html

04 June 2014 exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why?...

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

Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-push-multi-select-picklist-containing-commas-from-crm-to-creator.html

20 April 2020 FAILS {"My_MultiPicklist":["Option1","Options 2"," 3"]} How? So the way to push this value over to Creator is by converting the list to a string... notably comma delimited: // Reading CRM: l_MyMultiPicklist = List:String();...

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

Zoho Deluge: Convert Map to HTML Table without a FOR loophttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-html-table-without-a-for-loop.html

11 January 2021 A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I use a for loop. I have a map with 3 columns: first_name, last_name,...

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

Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://www.joellipman.com/articles/crm/zoho/zoho-crm-permission-denied-for-quote-conversion-mapping.html

02 September 2021 Map your fields that you want and click on "Save" Re-click on "Organize Modules" and disable the "Invoices" module. Test converting a quote to a sales order and check the fields mapped correctly. Source(s): the amazing Zoho Support team

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

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM signatures seem to be unable to handle a lot of code or long URLs such as a base64 source...

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

Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-hex-to-rgb.html

11 October 2024 A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't...

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

Zoho CRM Client Script: Map Quote to Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-client-script-map-quote-to-invoice.html

09 October 2025 of the invoice to TBC when first created. Maps values from the related quote if loaded from somewhere other than converting quote to invoice.". Note that I have a workflow that when saved, uses an auto-number field, pads it with zeros, and prefixes it...

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

Trim values along with the tabhttps://www.joellipman.com/articles/database/mysql/trim-values-along-with-the-tab.html

13 June 2016 MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. Unfortunately, the MS Excel software adds tab characters to delimit the columns... How? UPDATE...

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

MS Excel - Open CSV with Long Numbershttps://www.joellipman.com/articles/microsoft/excel/ms-excel-open-csv-with-long-numbers.html

23 July 2019 This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID...

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