Assuming time is required, the following 230 results were found.
-
note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing time of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
who modified the attachment. Created By Id: This is a "zcrm_" prefixed ID of the user who created the attachment. Created Time: This is the created time of your file in the format that your CRM system is using (eg. "dd/MM/yyyy HH:mm:ss") Modified Time:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
@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: *
-
@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
-
An article to document how I calculated the start and end dates of when Daylight Savings Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Just wanted a note to get in my head the logic if checking a requested time slot isn't a double-booking (as in, the time slot doesn't overlap a previous booking. How? Given a date/time and a duration, we will work out the requested start and end time:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
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: *
-
-- Ensure ID (primary key) match up on both systems unless you have -- custom usergroups. -- I did not have to do it this time but shout if you need help -- ********************************************************************** -- USERS: (but with...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
- Type: Article
- Category: Static Items
- Language: *
-
Because I find a need to document anything that takes longer than 30 minutes to figure out so I don't spend so long the next time I have to do it. The use-case scenario here is that when an appointment is made for a Lead in a booking system, we want a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an issue relating to the Time Server Synchronization error. Basically you start up windows live messenger and get the following error: {rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox}...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
2007 SP2...with ODBC to... MySQL v5+...hosting database... ActivityLog...contains activity, staffID, resourceID, start time, end time... Report Specification PivotTable Report...resources in row (along the side)......staff in columns (along the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you are happy with any changes....
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
/XO -- /E makes Robocopy recursively copy subdirectories, including empty ones. -- /XC excludes existing files with the same timestamp, but different file sizes. -- /XN excludes existing files newer than the copy in the source directory. -- /XO excludes...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
and takes far too long, especially the part of adding the various field placeholders onto the template document; every time. What if I told you we can code a single button on the record which does all of that for you; with only you needing to approve...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
epoch) 1309785651 %S SS second 00–60 (The 60 is necessary to accommodate a leap second) %N nanoseconds 000000000–999999999 Time %r hours, minutes, seconds (12-hour clock) 01:20:51 PM %R hours, minutes (24 hour clock) hh:mm e.g. 13:20 %T hours, minutes,...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
script.*/ using System; using System.Data; using Microsoft.SqlServer.Dts.Pipeline.Wrapper; using Microsoft.SqlServer.Dts.Runtime.Wrapper; using System.Globalization; // for cultureinfo and textinfo using System.Reflection; // for looping through...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I understand and can customize to fit my needs. This PHP function accepts as parameter a SQL date (or date format that strtotime() can convert) and outputs the largest unit (for example "1 year" not "1 year 2 months 3 days, etc..."). function...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
tip or note to self: How to get yesterday's date irrespective of date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB