Search - Joel Lipman .Com

1. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... Queries eBay for all orders given a from and till date Date Created: 2023-02-28 (Joel Lipman) - Initial release Date Modified: ???? - ??? More Info: ...; Created on 28 February 2023
2. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
3. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging ...; Created on 19 October 2022
4. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? ...; Created on 14 February 2022
5. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; What? I already have an article documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want ...; Created on 11 November 2021
6. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; What? A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are ...; Created on 10 September 2021
7. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd): / Zoho /; What? A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. ...; Created on 01 September 2021
8. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. ...; Created on 17 May 2021
9. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Zoho CRM Invoices and noticed that Xero stores its dates in Unix Timestamps. How? We're going to filter out the unix seconds from the date provided by Xero then apply a toTime() function to it. v_XeroTime="/Date(1586995200000+0000)/"; v_StartIndex ...; Created on 04 May 2020
10. Zoho Deluge - Determine Quarter from Date with Fiscal Year: / Zoho /; What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal ...; Created on 31 January 2020
11. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
12. Zoho Deluge - Update Creator from CRM: / Zoho /; What? This is an article documenting how to update Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where ...; Created on 18 February 2019
13. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; Applies to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. ...; Created on 15 April 2014
14. MS Excel - Sort pivottable column headings by date: / Excel /; ... and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays come before Mondays... but what's wrong with this equation? You can tell me that ...; Created on 12 April 2013
15. SSIS Convert a string into a date: / SQL Server Integration Services /; What? Please note: the following article is not a solution but a page of various methods and date conversions which I try and use depending on the situation. This is a quick article on how I got time ...; Created on 14 March 2013
16. Quickly update all content in mySQL database replacing a string: / MySQL /; What? This is an article on how to replace a string with another in all your joomla articles without modifying other data such as modified date and author. Why? I used to have a third-party plugin ...; Created on 03 February 2013
17. AutoHotkey Format Date and Format Seconds: / AutoHotkey /; As you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it' ...; Created on 20 September 2011
18. SSRS / MDX Date Queries: / SQL Server Reporting Services /; So I find myself using date ranges endlessly as I've been working in SSRS. The below is derived from a collection of various sources across the web as well as some of my own. These are what worked in ...; Created on 03 August 2011
19. Unix Date Format Specifiers: / Linux /; I could just remember to search wikipedia for "Date (Unix)" or search my site for "Unix". This was easier. Source: Wikipedia: Date (Unix) Format specifiers (format string starts with +) ...; Created on 05 July 2011
20. Difference between two dates - the midnight hour: / Web-Development /; ... the same date, when one of the hours is on the other side of the midnight hour... Now bear in mind the below is in European date format Consider the following: Date Customer ...; Created on 06 April 2011