Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just...

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

Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-compare-time-and-currenttime-with-timezone.html

13 January 2020 This is a quick article to demonstrate how to compare two datetime values with the timezone specified. Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 even for REST API v2.0 would have been something like the following: // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // // build up product details JSON to send m_LineItemProduct = Map();...

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

Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

26 August 2021 m_Record.put("Name",""); m_Record.put("Address",""); m_Record.put("Territory",""); // // split values by commas l_FieldValues = r_Data.toList(","); if(l_FieldValues.size()>0) { m_Record.put("EmployeeID",l_FieldValues.get(0)); }...

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

Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

17 November 2021 following: Source(s): Zoho Creator/Deluge: Insert rows in Subform Quick refresher: // declaring the row = .(); // assigning values for various subform fields in the row . = ; . = ; // declaring another row (declare as many rows as required) = .(); //...

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

Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

15 December 2021 in r_Response.get("fields") { if(r_Field.get("api_name") == "Customer_s_Timezone") { // loop through all the picklist values of this dropdown for each r_TimeZone in r_Field.get("pick_list_values") {...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://www.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 manages their domain, then they can give the following instructions to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this article, this is...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 key is mandatory when you include Who_id and What_Id. FREQ (String): Defines the frequency of the reminder. The possible values are DAILY, WEEKLY, MONTHLY, YEARLY, NONE. If you specify, NONE, the system sets a one-time reminder and TRIGGER becomes...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 a similar article on this website but the article below documents the full process to create a button that will map the values/fields from the record into a CRM Mail Merge template and send it off for signing, then return the Signed document attached to...

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

SSRS Subscriptions cannot be createdhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 ie. A sql authenticated user with read-only privileges. The report has 4 parameters, two of them use the default values (from and to date range) and two use specified values (setup in the subscription section). The report being subscribed to is hidden...

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

Report Builder 2.0 - Hide Series1https://www.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 WHERE _SMDBA_.Incident.[Group Name] LIKE @GroupName Based on the assumption that "Series1" displays on my chart because of values that are not matched (not assigned to a current individual) in the joining tables: Return to the Design interface (F8)...

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

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = 10 Const OBJ_EXTPEN = 11 Const OBJ_ENHMETADC = 12 Const OBJ_ENHMETAFILE = 13 ;#End Region ;#Region WM_MENUCHAR Return values Const MNC_IGNORE = 0 Const MNC_CLOSE = 1 Const MNC_EXECUTE = 2 Const MNC_SELECT = 3 ;#End Region ;#Region Background Mode...

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

Unix Date Format Specifiershttps://www.joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month...

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

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 --- Fix Included in file release version (link to version file ID) - Added Admin Section: Dropdown Options --- Priority Values (immediate, high, medium, low) --- Progress Status Indicators (red, green, orange) --- Progress Status Types (received,...

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

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the values they were submitted with. TimeStart datetime NOT NULL Time report started to run. TimeEnd datetime NOT NULL Time report...

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

SSRS Parameters in Oracle Stored Procedurehttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-parameters-in-oracle-stored-procedure.html

02 September 2011 is not to use any of these and to use the GUI dialog of the "Dataset Properties" for that stored procedure. The variable values will be prefixed with @ for SQL Server and not the colon (:) we expected for Oracle. Passing in Variables I've been told that...

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

T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

11 October 2011 need to add an actual row separating the different days which is either blank or full of hyphens/dashes. Stage #2: Replace values in last data row with blanks The trick to this is to get Stage #1 working for you with your query and then for every column...

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 Level AlphaNumeric Check You may have better ways to do this but here are my database level checks for alphanumeric values: -- ORACLE -- 0 if is alphanumeric, 1 or more if not alpha numeric. SELECT (LENGTH(TRIM(TRANSLATE(:ParameterToCheck,...

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

Getting the mysql where in delimited string to workhttps://www.joellipman.com/articles/database/mysql/getting-the-mysql-where-in-delimited-string-to-work.html

02 January 2012 delim, '')))/LENGTH(delim) + 1; -- get total number delimeters and add 1 -- add 1 since total separated values are 1 more than the number of delimiters -- start of while loop WHILE(ctr

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 a string of your choice; and even if you NVL all returned fields, no rows are returned, and not a row of NULL/blank/empty values. Sounds confusing? That's just me, the answer was using two NVL functions which allowed the stored procedure to return no...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB