Zoho Deluge: Generate List of TimeZoneshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 Africa/Ouagadougou Africa/Porto-Novo Africa/Sao_Tome Africa/Timbuktu Africa/Tripoli Africa/Tunis Africa/Windhoek America/Adak America/Anchorage America/Anguilla America/Antigua America/Araguaina America/Argentina/Buenos_Aires America/Argentina/Catamarca...

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

Zoho Creator/Deluge: Calculating with Timezone Offsethttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-deluge-calculating-with-timezone-offset.html

07 December 2021 use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to "US/Eastern" or "America/New_York" (-05:00). Our sales person is on the west coast in the timezone "America/Los_Angeles" (-08:00). And our customer...

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

SSIS Multiple Lookups in onehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-multiple-lookups-in-one.html

05 August 2014 000 England 39 British National 39 Other Asian Background 0000000002 0987654 MAJ Major Big Bird M Male 771 United States of America 771 United States of America 15 United States Citizen 15 Gypsy or Traveller

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

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

18 November 2021 = zoho.crm.getRecordById("Calls",123456789012345678); info r_CallDetails; // // system/application is set to EST (America/New_York) v_SystemCallTime = '2021-11-19 11:12:34'; // // manual setting to specify system/application offset...

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

Zoho CRM: Schedule a Meeting using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 the start time m_ScheduleMeeting.put("Start_DateTime",zoho.currenttime.addBusinessDay(1).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York")); // // the end time...

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