Assuming 4 is required, the following 113 results were found.
-
weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 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...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
A quick article on how to get the value of 40°4′20″N 116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B -------------------------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
(moved) and the connection "zbooks" has a fullaccess scope: // // initialize v_PaymentMode = ""; v_PaymentDate = null; v_Last4Digits = ""; r_UpdateInvoice = Map(); // // evaluate v_InvoiceID = invoice.get("invoice_id"); v_CustomerID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
var v_DealRate2 = r_DealDetails.Rate_Year_2_0; var v_DealRate3 = r_DealDetails.Rate_Year_3_0; var v_DealRate4 = r_DealDetails.Rate_Year_4_0; // default setting for alerting user let b_ShowAlertMessage = true; // specific values based on trigger field if...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
click Purpose: Preps stripe terminal to take payment for balance of invoice. Inputs: invoice Outputs: - Date Created: 2023-02-24 - Initial release - Reads Books Invoice and sends the amount to the reader for a payment atempt Date Modified: 2023-02-24...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
login, then search for Xero. fn_Xero_MapTaxRates This function used to take a Xero TaxType name and return a Zoho Tax ID (64-bit unsigned 19 digit integer) but that's more use when writing to Zoho Books. Within ZohoCRM, we only need the name and in this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
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 (dd) 4 %j day of year, zero padded 001-366 %u day of week starting with Monday (1), i.e. mtwtfss 1 %w day of...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
only as well... Ok I admit I only googled for about 1 hour before I gave up and just wrote my own. Saying that it's taken me 4 hours just to do the below... hopefully it will be quicker next time now that I noted it all down. The SQL Script: DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
that I've suffixed a comma to but I want to display this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
This is an article to document the migration of a Joomla! CMS running version 2.5.11 to an instance of Joomla! CMS version 3.4.1. I would consider the below instructions an ALPHA version as it is considered unstable for official use... Saying that this...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
to: MySQL Database v5.0.45 MySQL Workbench v6.0.8.11354 build 833 What? This is a quick article on how to get around the problem of backing up your MySQL database when attempting to "Data Export" using MySQL Workbench. This is not regarding the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
- Type: Portfolio Item
- Language: *
-
Audio Posthttps://www.joellipman.com/component/tags/tag/audio-post.html
- Type: Tag
- Language: *
-
Uncategorisedhttps://www.joellipman.com/component/contact/category.html?Itemid=165
- Type: Category
- Language: *
-
Support Sean for creating the COM Standard Library tank for the tutorial listed above, & daonlyfreez tank, sinkfaze, & jaco0646 for reviewing this tutorial Terms - The following terms will be used throughout this tutorial. You may use these links for a...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
ThisDate:=SubStr(val, 1, InStr(val, " ")) ThisDate=%ThisDate% ThisDate:=SubStr(ThisDate, 7) . SubStr(ThisDate, 4, 2) . SubStr(ThisDate, 1, 2) ThisDate=%ThisDate% val=%ThisDate%%ThisTime% } FormatTime, val, %val%, ddd dd-MMM-yyyy HH:mm:ss Return val } //...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
= v_NextMonthDate.toStartOfMonth(); if(v_NextMonthDateFirst.getDayOfWeek()!=2) { for each v_MyDay in {1,2,3,4,5,6,7,8} { v_NextMonthDateFirst = v_NextMonthDateFirst.toDate(); v_NextMonthMonday = v_NextMonthDateFirst.addDay(v_MyDay);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
// // regex change dd/MM/yyyy to yyyy-MM-dd v_RegexdDate = v_TestDate.replaceAll("(\\d{2})/(\\d{2})/(\\d{4})","$3-$2-$1", false); info v_RegexdDate; info v_RegexdDate.toDate(); info v_RegexdDate.toString("E, d MMM yyyy"); info "*********************";...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
ZohoInventory.shipmentorders.READ // // init (put your own ZohoBooks/ZohoInventory Org ID v_BooksOrgID = 123456789; // // check the form was ticked and there is a package ID specified if(input.Mark_as_Complete && input.Zoho_Package_ID != "") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *