Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects-get-all-events.html

22 July 2024 = ifnull(r_PastEvents.get("events"),List()); for each m_PastEvent in l_PastEvents { // // convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

MySQL Data Type Reference Tablehttps://www.joellipman.com/articles/database/mysql/mysql-data-type-reference-table.html

15 February 2010 to "9999-12-31" Date/Time Time 'HH:MM:SS', 'HHMMSS', 'HHMM', 'HH' 3 bytes Range "-838:59:59" to "838:59:59" Date/Time DateTime 'YYYY-MM-DD HH:MM:SS' 8 bytes "0000-01-01 00:00:00" to "9999-12-31 23:59:59" Date/Time TimeStamp 19700101000000 to sometime in...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

SSIS Convert a string into a datehttps://www.joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

14 March 2013 + "/" + SUBSTRING(This_Date,7,4)) -- if data source column is of datatype string and european date format: return SQL datetime (TRIM(This_Date) == "") ? (DT_DBTIMESTAMP)"1900-01-01" : (DT_DBTIMESTAMP)( SUBSTRING(This_Date,7,4) + "-" +...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

Android: Replace return key with done, go, send...https://www.joellipman.com/articles/google/androidos/android-replace-return-key-with-done-go-send.html

03 November 2014 sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a date and time date // selectable date time // selectable time android:imeOptions normal actionUnspecified...

• Type: Article
• Author: Joel Lipman
• Category: AndroidOS
• Language: *

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 v_CustomerCallTime = '2021-11-19 08:12:34'; // // set system/application date time start in CRM format v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset; // // set system/application date...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London") + v_TimeZoneOffset; Note(s): This was done in...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 you want to remind the task owner about the task. The possible values are EMAIL, POPUP, EMAILANDPOPUP. TRIGGER=DATE-TIME (DateTime ISO8601): Defines when you want to trigger the reminder. Example: 2020-05-01T12:28:00+05:30. TRIGGER=TIME (hh:mm): 24-hour...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *