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. ...
... e Meeting");
//
// 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
m_ScheduleMeeting.put("End_DateTime",zoho.currenttime.addBusinessDay(1).addMinutes(30).toString("yyyy-MM-dd'T'HH:mm:ss","America/New_York"));
//
...
What?
This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify.
Why?
Previously, we would receive an eBay notification and create an ...
... data per column (in this example, I highlight the Date column, it then prompted me what format this is in, eg. dd/MM/yyyy):
You will then be shown a summary of your import:
You can then ...
... Start Starts Second Sunday in March at 2:00
DST End Ends First Sunday in November at 2:00
//
// Starts Second Sunday in March at 2:00
v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") ...
... sunday but we want to start counting from Monday 00:00
v_FirstDateOfWeek = zoho.currentdate.toStartOfWeek().addDay(1).toString("yyyy-MM-dd");
//
// build up COQL Query
v_CoqlQuery = ...
... start in CRM format
v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") + v_ApplicationTimeOffset;
//
// set system/application date time start in US format
v_CustomerAppointmentDateTimeStart ...
... timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field:
//
// parse date into yyyy-MM-dd (using subString - reliable)
v_LeadCreatedDate = r_LeadDetails.get("Created_Time").subString(0,4) ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.