Search - Joel Lipman .Com

1. 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
2. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ...; Created on 21 September 2021
3. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy ...; Created on 30 July 2021
4. Zoho Deluge: Zoho Bookings Get Available Slots: / Zoho /; ... r_Staff in l_Staff { if(!isnull(r_Staff.get("id"))) { v_StaffName = r_Staff.get("name"); } } Get the Available slots: // // get available slots r_AvailableSlots = zoho.bookings.getAvailableSlots(v_ServiceID,v_StaffID,v_ThisDate.toString("dd-MM-yyyy"),"joels_connector"); l_AvailableSlot ...; Created on 23 June 2021
5. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... commas v_NewCSVline = "\"" + v_ThisEventTime.toString("yyyy-MM-dd HH:mm:ss") + "\",\"" + v_ThisEventNote + "\""; l_NewCSVrows.add(v_NewCSVline); } // // generate CSV v_CSVFilename = "audit-log-" ...; Created on 16 June 2021
6. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... ", "0"); v_HoursHHmm = v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm); m_CreateTimeLog.put("start_time",v_StartTime.toString("hh:m ...; Created on 30 April 2021
7. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... v_ThisFileSize = ifnull(m_ThisFile.get("file_Size"),"-"); v_ExpiryTime = zoho.currenttime.addMinutes(10).toString("dd-MMM-yyyy HH:mm:ss"); // // put your own Publish key here (publish th ...; Created on 02 February 2021
8. Zoho Deluge: Sort a Map by a specific field: / Zoho /; ... date format), arrange so it can be sorted alphabetically in reverse order v_DatePart = v_SortingKey.getPrefix("T").toDate().toString("yyyy-MM-dd"); v_TimePart = v_SortingKey.getSuffix("T").getPrefix("+").subString(0,5); v_SqlDateTime ...; Created on 29 January 2021
9. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... can book longer than a month): // set criteria to search for clashing annual leave dates (pre/post 1 month check) l_SearchCriterias = List(); m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","From"); m_SearchCriteria.put("searchOperator","After"); m_SearchCriteria.put("searchText",v_GivenDateFrom.subMonth(1).toString("dd-MMM-yyyy")); l_SearchCriterias.add(m_SearchCriteria); m_SearchCriteria ...; Created on 10 December 2020
10. Zoho Deluge: Duplicate/Clone a Record: / Zoho /; ... now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd")); m_Clone.put("Due_Date",zoho.currentdate.addMonth(1).toStartOfMonth().subDay(1).toString("yyyy-MM-dd")); // ...; Created on 17 March 2020
11. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time field and you get the error: v_MyDateTimeString = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ssZ"); // ...; Created on 06 February 2020
12. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; ... and appending toTime() prematurely - DO NOT USE v_CustomTime = "2020-03-25 20:41:07".toTime().toString("yyyy-MM-dd HH:mm:ss"); v_ExpiryTime = "2020-03-25T21:41:07+00:00"; info v_CustomTime.toTime(); info ...; Created on 13 January 2020
13. Zoho Deluge - Get English Ordinal: / Zoho /; ... + v_NextRenewalDate.toString("MMMM, yyyy"); info v_ContractDateFormatted; // yields Tuesday, 6th of November, 2018 Method #5: if a list contains: v_NextRenewalDate = '2018-11-06'; v_EnglishOrdinal ...; Created on 08 November 2018
14. Add attribute xsl:nil=true on empty elements using XSLT: / XML Stylesheet Language Transformations /; ... that date of birth from SQL format (yyyy-mm-dd) to European format (dd/mm/yyyy)? See the following: -- assuming value of ...; Created on 18 August 2014
15. AHK Countdown Tooltip: / AutoHotkey /; ... " A_Hour ":" A_Min " on " A_DDDD ", " A_DD " " A_MMMM " " A_YYYY "`n`nAnd it's time for that gentle reminder..." Message1:="In total...`nYou have " ThisManyWeeksMessage " left at BU.`n`n ...; Created on 17 July 2014
16. SSRS Display question mark when date is blank: / SQL Server Reporting Services /; ... "dd/MM/yyyy HH:mm:ss") -- yields 11/02/2014 11:21:32 Sounds good, where's the problem? The problem Putting the date in an IIF (if-then-else) statement displays "#Error". You should get errors ...; Created on 15 April 2014
17. MS-DOS: Copy folders without overwriting files: / MS-DOS /; ... else n = YYYYMMDD date). /XJ :: eXclude Junction points. (normally included by default). /FFT :: assume FAT File Times (2-second granularity). /DST ...; Created on 23 February 2014
18. SSIS Convert a string into a date: / SQL Server Integration Services /; ... conversion working in an SSIS package which read from a text file. Note that the example below converts a string in European Date Format (ie. "ddmmyyyy" to "dd/mm/yyyy"). Also, my data flow imports two ...; Created on 14 March 2013
19. Cheat Sheet for mySQL vs t-SQL: / Databases /; ... (dd/mm/yyyy) DATE_FORMAT(now(), '%d/%m/%Y') CONVERT(varchar, getdate(), 103) Time to Seconds TIME_TO_SEC(now()) (DATEPART(hour, getdate()) * 3600) + (DATEPART(minute, getdate()) * 60) + (DATEPART(second, ...; Created on 31 January 2013
20. Generate Academic Calendar using MySQL: / MySQL /; ... 1, 3) + '-' + CAST(DATEPART(yyyy, calendar.StartDate) AS VARCHAR(4)) AS Monday, CAST(DATEPART(dd, DATEADD(d, 1, calendar.StartDate)) AS VARCHAR(2)) + '-' + SUBSTRING(DATENAME(mm, DATEADD(d, 1, calendar.StartDate)), ...; Created on 27 November 2012