Assuming start is required, the following 98 results were found.
-
field is a text line field called Customers_Requested_Time and I have added a few more date time fields called GMT_Date_Time_Start, GMT_Date_Time_End, System_Date_Time_Start, System_Date_Time_End, Agent_Date_Time_Start, and Agent_Date_Time_End: //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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: *
-
a minimum (or CREATE/READ): 2. Code to push Time Log entry to Zoho Projects: Example #1: Pushing a time log with a specified start date/time (requires end time field if using): // // init (from dropdowns you have made applicable to your Zoho Projects...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM Timetable ORDER BY StartDate ASC, AnotherOrderByCol ASC, AndAnotherOrderByCol ASC -- Yields /* Day...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
slide with contents of the displayed slide. Hide currently displayed slide to expose the first slide again (restores the starting position of "next slide"). The Gist Strategy This may not be a great idea, I'm just trying something out. The brief was...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
it is called "Which_rate_card_is_this_based_off". The expected outcome is the appending of a row to the subform based on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for each r_Row in input.Mondays { if(r_Row.In_Effect) { // get Monday entries/rows v_EventType = r_Row.Event_Type; v_EventStart = r_Row.Start_Time; v_EventEnd = r_Row.End_Time; // // create Tuesdays subform entries r_RowTu = Shifts.Tuesdays();...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
TFS (vs2010), SSRS 2008 R2. The following examples assume today's date is Wednesday 03 August 2011 @ 11:46: This Week: -- Start Date (US format - mm/dd/yyyy) =DateAdd("d", -(WeekDay(Today(),2))+1, Today()) // yields: 8/1/2011 -- End Date (US format -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Situation The requirement in a lot of my reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
disabled if offline - [1.8.0] Pilot: join/login auto-selects email - [1.8.0] Pilot: profile page with preferences - [1.8.0] Start: fetches current lat/lng - [1.8.0] Start: launch section enabled - [1.8.0] Help: re-categorized law, how-to, ToS - [1.8.0]...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
// customer is in (America/Los_Angeles) v_CustomerCallTime = '2021-11-19 08:12:34'; // // set system/application date time start in CRM format v_SystemAppointmentDateTimeStart = v_SystemCallTime.toString("yyyy-MM-dd'T'HH:mm:00") +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
that we're going to create a scheduled task (that won't be scheduled) and a shortcut to that task: Open the Task Scheduler (Start > Run... > Type taskschd.msc > OK) - You will need administrator rights for this step. Click on Create Task... Under the...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Standard Library - for use with AHK Basic Purpose The purpose of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages, similar to how the AHK Control...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
+ " "; Generate a list of working dates given a number of days So here's another scenario where you have a start date and you are asked to list the working days, 7 days after the start date. I'm aware of the method .workdaysList(): date1='2022-07-21';...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
with private List readFeed(XmlPullParser parser) throws XmlPullParserException, IOException { parser.require(XmlPullParser.START_TAG, null, "rss"); String title = null; String link = null; String date = null; String desc = null; List items = new...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
Excel 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...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
1: The first line of my code 2: The second line of my code 3: The third line of my code How? Open a MS-DOS Command Prompt (Start > Run... > Type "COMMAND" > Enter) [Optional] Browse to the folder that contains the file (or use full path in path...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
== "Subform1") { // loop through the first subform of this record for each r_SubformRow in r_Record.mySubform1 { v_StartTime = r_SubformRow.Start_Time; } } // set an else if condition else if(r_Record.Type == "Subform2") { // loop through the first...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a sunday but we want to start counting from Monday 00:00 v_FirstDateOfWeek =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday but in the United Kingdom, the week generally starts on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *