Assuming determine is required, the following 48 results were found.
-
''; -- 1900-01-01 SET @TimeVal = ''; -- 00:00:00.000 SET @DateMatch = 0; SET @TimeMatch = 0; SET @ColumnTypeIsDate = 0; -- Determine if Given Value is date IF @OrigVal IS NULL RETURN NULL; -- Determine if Given Value is date IF ISDATE(@OrigVal)=1 SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
''; -- 1900-01-01 SET @TimeVal = ''; -- 00:00:00.000 SET @DateMatch = 0; SET @TimeMatch = 0; SET @ColumnTypeIsDate = 0; -- Determine if Given Value is date IF @OrigVal IS NULL RETURN NULL; -- Determine if Given Value is date IF ISDATE(@OrigVal)=1 SET...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= v_NextTime.toTime().toLong(); // // calculate seconds in between v_UnixSeconds = v_NextEpoch - v_NowEpoch; // // determine days v_Days = floor(v_UnixSeconds / 1000 / 60 / 60 / 24); info v_Days; v_UnixSeconds = v_UnixSeconds - (v_Days * 1000 * 60 * 60...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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 year starts from January, simply divide by 3... How? I'm showing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost of each item purchased; including shipping and tax. The second is to associate these to the invoiced items and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
What? If you're lucky enough to build an application for a client based in a country that changes its clocks twice a year, then I'm opening this article without a 100% certain solution as I need to wait about 4 months until I can confirm this works....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was hitting statement execution limits and rather than...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
£499.95 is correctly £416.62) Date Modified: 2023-02-23 (Joel Lipman) - Check if ebay Order ID already exists on system to determine whether to update or create. - Check if SalesOrder already exists on system to determine whether to update or create. -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
be reminded of how to calculate a percentage. The context here is that I want a progress bar in one of my programs. To determine what percent a number is of a total number: (Progress So Far / Total Progress Units) * 100 = % or (Net Amount / Gross...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in this department/team: To determine the total number of employees, we will use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
This means that if I click on Tuesday10March, this code will match "10" to the map and determine what index or offset this is from the starting date, which is "2". It can then determine which CSS element to highlight in a different CSS color, and which...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
environment variable: This allows you to use keytool from any folder: Open a command prompt Type CD C:\Program Files\Java Determine your JDK folder dir jdk* and append the \bin. Note this for later. Right-click on the "Computer" icon/label (desktop /...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
:= v_Monitor%A_Index%Left v_y1 := v_Monitor%A_Index%Top v_x2 := v_Monitor%A_Index%Right v_y2 := v_Monitor%A_Index%Bottom ; determine if leftest if(v_x1...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
]; How? So in the following example, we are going to setup a connection in Zoho Books on an EU datacenter: First determine what datacenter your client is using Register the App Setup the Connector How do I determine what datacenter to use? To find out...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
can be searched for with the "State" field on the Lead record. // // ************************************************ // determine customer timezone: BEGIN // v_CustomerTimeZone = ""; // // build up address from Lead to geocode l_LeadAddress = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
{ // // specify your own Inventory/Books organization ID v_BooksOrgID = 20221234567; // // determine URL of file to download (note the DC here is EU but yours might be COM) v_Url = "https://inventory.zoho.eu/api/v1/items/" + input.Zoho_Inventory_ID +...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
} // add currency code into column "Agreed Currency" json_Arg.Agreed_Currency = v_CurrencyCode; // the rate values we determine earlier json_Arg.Rate_Year_1_0 = v_DealRate0; json_Arg.Rate_Year_1_5 = v_DealRate1; json_Arg.Rate_Year_2_0 = v_DealRate2;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
creating a custom module where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" module which then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
= o_ThisLineItem.Vendor_Currency; // going to create a new set of line items a_NewSuformRows.push(o_NewLineItem); } } } // determine deposit amount // get grand total (note that formula for grand total excludes line items which were optional)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *