Assuming start is required, the following 95 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
- 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
- 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
- Language: *
-
T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html
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
- Language: *
-
SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html
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
-
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
- Language: *
-
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: *
-
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: *
-
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
- 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: *
-
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
-
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: *
-
+ " "; 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
- Language: *
-
Business, Ultimate), and Windows XP Service Pack 3 (SP3). Creating a Virtual PC: Download & Run the setup.exe Go to Start > Programs > Microsoft Virtual PC In the wizard, select "Create a virtual machine" > Next Name it (eg. Test VirtualPC 001) > Next...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
with a single-space return $str; } # highlight terms within search results function search_highlight($text, $terms_rx){ $start = '(^|)'; $end = '($|)'; return preg_replace( "/$start(.*?)$end/se", "StripSlashes('\\1')."....
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- 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
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF