Assuming times is required, the following 50 results were found.
-
which is possibly all your data being mapped, associated, and imported... I personally had to refresh the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for each v_Day in l_DaysCorrectOrder { m_ShiftBuildUp.put(v_Day, m_ShiftRow); } // // ok let's get the opening times if(m_OrgDetails.get("custom_timing") != null) { l_CustomTimings = m_OrgDetails.get("custom_timing"); for each r_Timing in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Here we need to loop through all the available pages, so including the above plus some calculation to work out how many times to loop should retrieve every thing: // // initialize l_AllProducts = List(); v_TotalCategories = 0; v_TotalProducts = 0;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
time to store the record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
boolean to indicate deprecation notification.notificationId unique identifier of the notification notification.eventDate timestamp indicating when eBay user made the data deletion request notification.publishDate timestamp indicating when current...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
- Date Created: 2025-10-08 (Joel Lipman) - Initial release Date Modified: 2025-10-13 ( Joel Lipman) - Parsing Xero Dates and Times to include timezone of Xero instance for accurate time comparisons - Map Xero tax rates to Zoho tax rates (same names in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
them into ZohoCRM Inputs: - Outputs: - Date Created: 2025-10-13 (Joel Lipman) - Initial release - Parsing Xero Dates and Times to include timezone of Xero instance for accurate time comparisons Date Modified: ??? - ??? More Information:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
I made along the way. When a Zoho Books bank feed stops syncing in the United Kingdom, there are a few possible causes. Sometimes the issue is with the bank or the Open Banking token, but other times the feed itself becomes stuck and cannot be refreshed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
of if you have not come across it before. Why? In many Deluge scripts, assignments are often more than a single value. At times, it can be useful to copy and paste or temporarily format logic across multiple lines to improve readability while writing or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
using the ReportServer database in SSRS 2008 R2: SELECT Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun, DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun, DATEPART(year,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Reporting Manager Problem #2: Alternative image if file does not exist We don't have photos for all ~20000 students at all times and these get updated/uploaded/added to about once a week. In cases where there are no photos, SSRS displays a mini ugly red...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
will compare the time taken for each one. The breakdown or what I was able to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these. I haven't Googled this at the time of...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 dropdown populated by a list of all available reports. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
when dealing with languages other than English. Preserving files in unicode or utf-8 encoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
) String Length LENGTH(string) BIT_LENGTH(string) CHAR_LENGTH(string) LEN(string) DATALENGTH(string) Dates / Times Weekday Name DAYNAME(now()) DATENAME(dd, getdate()) Weekday Number DAYOFWEEK(now()) DATEPART(dw, getdate()) Month Name MONTHNAME(now())...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
"ddd dd/MM/yyyy")... Mon 04/04/2011 European and Now: The above is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
FROM Dates d LEFT JOIN Events e ON CAST(CONVERT(VARCHAR(10),e.EventDate,101) AS DATETIME) = d.[Date] --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) I'd appreciate if you bear with me as I add captions to the below...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
@NewVal varchar(max); DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
** ** - myValue: the distinct values ** ** - myColumn: the column this value was found in. ** ** - myCount: the number of times this value was found in this column. ** ** ** ** Link to other SQL Server collations:...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
@OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; DECLARE @RandString varchar(max); -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB