What?
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would ...
Applies to:
MS SQL Server Management Studio 2008
Two Transact-SQL databases
What?
A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without ...
... = ceil(v_MaxCount / v_PerPage);
info v_Pages;
Call with datetime criteria:
NB: You can't compare a date time value to a field that is simply of datatype: date
v_PerPage = 200;
v_CountCriteria ...
... checking if daylight savings is in effect in the UK, we should be able to take Greenwich Mean Time and compare to UTC.
b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", ...
... CRM Contacts and select "Deduplicate Contacts", then say compare by email and the foreign key (3rd-party unique ID for that contact).
Error(s) Encountered
Could not find a matching parent record ...
... var json_Row = new Array();
var json_Arg = new Object();
// get some values beforehand which allows us to compare to the rows already present in the subform
// first column to add ...
... I created to store the record details of properties. It was a quicker way of detecting a change on the record rather than comparing all the fields, compare only 1 value which is a hash or MD5 of all the ...
... If your datacenter is in the US then this should be zohoapis.com.
Additional Additional(s):
I haven't done any benchmark tests on this to compare but looking at different ways to exclude elements ...
... this more and more now that API v1 is on the way out and Zoho Deluge by itself is limited somewhat with regards to functionality and record editing when compared to API v2.
How?
Note that this is ...
... of using MD5 in an encryption task.
Why?
I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can' ...
What?
A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...
... rate).
Note that my servers are based in Houston, Texas, USA (due to their traffic [when europe is active, these are not and vice-versa] and resilience [99.99% uptime] status compared to European ...
What?
I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...
Why?
I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able ...
... all accounts irrespective of being activated or not). It needs to pick up trends as well and compare for example todays, with yesterdays up to the same hour.
How?
I used to use a lot more PHP but ...
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.