Search - Joel Lipman .Com

1. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday ...; Created on 06 July 2023
2. MySQL day of week ending on Friday: / MySQL /; What? Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. ...; Created on 26 April 2012
3. MySQL last year week month day trend periods: / MySQL /; Why? I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count ...; Created on 31 October 2011
4. Inserting incremental weeks in MySQL: / MySQL /; Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different ...; Created on 15 April 2011
5. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = m_ThisData.get("attributes").get("Permalink"); } } } } } // ==================================== // send an email with the permalink v_Subject = "Data for Export w/c: " + zoho.currentdate.toStartOfWeek().toString("yyyy-MM-dd"); v_Messag ...; Created on 11 September 2024
6. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... to ask us to build this solution for you. It can take a few days but it will save your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use ...; Created on 06 August 2024
7. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... doesn't do the popup on the CRM as well. A workflow notify by email didn't give the option to remind daily... only weekly or monthly. Spent a while trying not to use code but here we are. Code is ...; Created on 14 May 2024
8. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... "days": "Saturday", "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, ...; Created on 28 March 2023
9. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022
10. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
11. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; What? Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous ...; Created on 09 March 2022
12. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; ... Transfer Protocol on a Port number of your choosing: Set for new imports to append, replace, or check if exists then insert/replace: Schedule to repeat: Every X Hours, Every Day, Weekly, Monthly: ...; Created on 12 January 2022
13. Zoho Deluge: Calculate start and end of Daylight Savings Time: / Zoho /; ... + "-03-08 02:00:00"); // // Ends First Sunday in November at 2:00 v_LastMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-11-01 02:00:00"); // // loop through each day in a week to get the start ...; Created on 07 December 2021
14. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... single out this person (can be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a ...; Created on 02 December 2021
15. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... the .addDay(), check none of these are a Sunday, and move the next few days along: thisDate = '2021-10-30'; v_Today = thisDate; v_Tomorrow = v_Today.addDay(1); v_NextDay = v_Today.addDay(2); if(v_Today.getDayOfWeek()==1) { v_Today ...; Created on 02 November 2021
16. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; ... of Month") { v_NextMonthDate = zoho.currentdate.addMonth(1); v_NextMonthDateFirst = v_NextMonthDate.toStartOfMonth(); if(v_NextMonthDateFirst.getDayOfWeek()!=2) { for each ...; Created on 27 September 2019
17. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
18. Zoho Deluge - Get Full Day Name: / Zoho /; What? This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters ...; Created on 08 November 2018
19. TravelPort Universal API - Ping Request with PHP-cURL: / API Miscellaneous /; Applies to: TravelPort Universal API PHP 4 or 5 cURL What? An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...; Created on 27 April 2015
20. AHK Countdown Tooltip: / AutoHotkey /; ... any more stupid, he'd have to be watered twice a week." Joke4:="He has two brain cells, one is lost the other is out looking for it." Joke5:="If you gave him a penny for his thoughts, you ...; Created on 17 July 2014