Assuming yields is required, the following 92 results were found.
-
5 seconds ago // then $v_Str = "17 minutes ago" Or how about $v_Str = getTimeAgo('-1 week 2 days 4 hours 2 seconds'); // yields "1 week ago" $v_Str = getTimeAgo('last Monday'); // yields "3 days ago" (it's Thursday) $v_Str = getTimeAgo('first day of...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
{ v_Quarter = (v_Month.toLong() / 3).ceil(); info "Month: " + l_MonthNames.get(v_Month-1) + " :: Quarter: " + v_Quarter; } Yields: Month: January :: Quarter: 1 Month: February :: Quarter: 1 Month: March :: Quarter: 1 Month: April :: Quarter: 2 Month:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
v_StartIndex); v_UnixSeconds = v_XeroTime.subString(v_StartIndex, v_EndIndex); info v_UnixSeconds.toLong().toTime(); // yields 15-Apr-2020 17:00:00 Chained v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_FormattedString = v_Test.replaceAll("(\"[^\",]+)[,]([^\"]+\")","$1|mySpecialComma|$2",false); info v_FormattedString; // yields: 00011,Joel Lipman,"Flat 8|mySpecialComma| House Corner",Brummieland // split into a list (string delimited by commas)...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ ", " + v_Hours + " " + v_HourGrammar + ", " + v_Minutes + " " + v_MinGrammar + ", " + v_Seconds + " " + v_SecGrammar ; // yields: 0 DAYS, 23 HRS, 54 MINS, 11 SECS Convert Total Minutes to Hours:Minutes This is for other scenarios: v_TotalMinutes =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
+ v_LeadStatus + "\""); m_Output.put("status","error"); } } // // return response return m_Output; Click "Save" and Done! Yields: Additional Note(s): If the user's profile is blank, the rule will not apply to them. l_Disallowed = List();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
"https://www.zohoapis.com/crm/v3/settings/business_hours" type: GET connection: "mycrmconnection" ]; info r_OrgDetails; Yields something like { "business_hours": { "business_days": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ],...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
l_Loop = " ".leftpad(5000).replaceAll(" ", ",").toList(); // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4999 Statement Execution Limit is 10000 If the below runs successfully, then the limit is at...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Trim in T-SQL and SSIShttps://www.joellipman.com/articles/microsoft/ssis/trim-in-t-sql-and-ssis.html
= 'JOE ' + CHAR(9) + CHAR(10) + CHAR(13) -- Before SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = 'JOE' -- yields 1 -- What we want (equivalent?) SELECT COUNT(*) FROM Employees WHERE Employee.ForeName = @EmployeeStr -- yields 0 -- After...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
like which appends the functions instead and is clearer for me personally to understand: // I want 010 v_NextIndex = 10; // yields 10 v_NextIndexStr = v_NextIndex.leftpad(3); // yields " 10" v_NextIndexStr = v_NextIndex.leftpad(3).replaceAll(" ", "0");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
Succeeding is FALSE"; } if(v_Test == "") { info "Equals Blank is TRUE"; } else { info "Equals Blank is FALSE"; } } // // yields /* ---------------------- Value of TEST is a BLANK String isBlank Preceding is TRUE isBlank Succeeding is TRUE isNull...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
default date as today's in the format DD/MM/YYYY. Googled this but couldn't find an answer, then I just replaced "=NOW()" [yields: 01/01/2011 01:00:00] with "=Today()" [yields: 01/01/2011] and this did the trick. English Ordinal Suffix in T-SQL for MDX...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
wikimedia_revision.rev_text_id=wikimedia_text.old_id AND wikimedia_text.old_text'' AND wikimedia_page.page_is_redirect=0 -- yields: let's call it MyTable1: Query time: 0.187s. 880 rows returned. PageID PageTitle PageContent ----------------...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
character "" -- join this array back replacing any spaces with nothing Examples: -- If field is "Joes Just Joking!" yields "JoesJustJoking!" -- If field is " Space is a big place " yields "Spaceisabigplace" Reminder: -- We're using this for a comparison...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
query: SELECT DISTINCT StudentDetail FROM StudentTable WHERE SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available') -- yields StudentDetail ----------------- Data Not Yet Available Which isn't at all what we set out to achieve other than it identified...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
= ref.RefMappedValue AND ref.[RefSheet] = 'myPayrollCategory' AND ref.[RefSystem] = 'myPayrollSystem' -- Yields "Conversion failed..." Working version: -- Corrected query (output values enclosed in apostrophes) SELECT CASE WHEN emp.ContributionValue=1...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
& " matching record" & IIF(Sum(Fields!myCount.Value, "DataSet2")=1, "", "s") & " found." ) -- Search for Joel Lipman yields "1 matching record found." -- Search for SMITH yields "Displaying the first 100 of 2732 results returned." We would not offer the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
[Academic Week], calendar.Monday, calendar.Tuesday, calendar.Wednesday, calendar.Thursday, calendar.Friday FROM calendar -- yields as above: -- Academic Week Monday Tuesday Wednesday Thursday Friday -- ---------------- ----------- -----------...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
else { v_PreviousValue = m_ProductCount.get(v_SKU); m_ProductCount.put(v_SKU,v_PreviousValue + 1); } } info m_ProductCount Yields: { "TEST001": 6, "TEST002": 1 } Counting total products per account: // // count total products per account m_Accounts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
2, 3"); // Push to Creator: m_CrmFields = Map(); m_CrmFields.put("My_MultiPicklist": l_MyMultiPicklist.toString(",")); // Yields ERROR: Failure, Invalid column value \"Options 2, 3\" specified // i.e. Cannot match picklist option in Creator (Options 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF