Assuming offset is required, the following 14 results were found.
-
= input.Customers_Requested_Time.toTime(); v_CustomerTimeZoneName = "(+01:00) Europe/Luxembourg"; v_CustomerOffset = "+01:00"; // // calculate GMT v_CustomerPlusMinus = v_CustomerOffset.subString(0,1); v_CustomerHours =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
date but more like the today's date minus 7 or plus 7 days depending on which way they navigate. We then need the offset so that when a user clicks on the #9 entry, the system will know this is March 9th 2022 and not June 9th 2021... To do this, we have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
info v_UnixSeconds; To normalize +0530 to include the colon +05:30, consider the following: // Normalize to +HH:MM offset = "+0530"; offset = offset.replaceAll("([+-]\d{2})(:?)(\d{2})", "$1:$3", false); Error: Argument type mismatch -Found 'TEXT' but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
where can contain up to 25 criteria. Use parenthesis for precedence. Pagination: LIMIT offset, limit: v_CoqlQuery = "select id, Deal_Name from Deals where ((Amount=0) and (Stage != 'Cancelled')) limit 400,2"; // returns 2 deals after the first 400...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product names (v2 up to 200, v6 up to 10k, v7 up to 100k) m_Params =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// NB: range is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index (not the ID of the record) m_Params = Map(); m_Params.put("range",50); m_Params.put("status","closed");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
REPLACE(haystack,needle,replacement) String Position INSTR(haystack, needle) LOCATE(needle, haystack [, offset]) PATINDEX(%needle%, haystack) CHARINDEX(needle, haystack [, offset]) String Concatenation CONCAT(string1,string2[,stringN]) string1 + string2...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
only) - Parameter: Popup Text Color - Parameter: Popup Border Color - Parameter: Popup Background Color - Parameter: Popup Offset X (relative to link) - Parameter: Popup Offset Y (relative to link) - Modify Parameter: Added Ordering: Random - Modify...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
Application.ActiveSheet.Range("A1").PasteSpecial Set xRow = xRow.Offset(SplitRow) Next Application.CutCopyMode = False Application.ScreenUpdating = True End Sub Press F5 to run the code. This will prompt you twice: It is prompting you for the range of...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
ParseDisplayName Or path ;#end region ;#region STRRETFlags Const STRRET_WSTR = $0000 ;// Use STRRET.pOleStr Const STRRET_OFFSET = $0001 ;// Use STRRET.uOffset To Ansi Const STRRET_CSTR = $0002 ;// Use STRRET.cStr ;#end region ;#region...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
set to EST (America/New_York) v_SystemCallTime = '2021-11-19 11:12:34'; // // manual setting to specify system/application offset v_ApplicationTimeOffset = "-05:00"; // // customer is in (America/Los_Angeles) v_CustomerCallTime = '2021-11-19 08:12:34';...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
var v_LocalStartDate = new Date(v_StartDateValue); // accommodate for timezone offset v_LocalStartDate.setMinutes(v_LocalStartDate.getMinutes() - v_LocalStartDate.getTimezoneOffset()); // return in yyyy-mm-dd format (on save this will display as per the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
position of the extract, and a third string (2a) to specify the closing position of the extract. NeedleMarker is the offset and means when this function is used for several tables, the Needlemarker tells the function to start from where it last found a...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink For Each HL In ActiveSheet.Hyperlinks HL.Range.Offset(0, 1).Value = HL.Address Next End Sub Press F5 and click “Run” Get out of VBA (Press Alt+Q)
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB