Assuming date is required, the following 167 results were found.
-
A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_MaxCount = ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = 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;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source, source_id, checked_out, checked_out_time, editor ) SELECT id, parent, CASE WHEN...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
new ones. Copy all users except the v25 admin to your v34 database (with status=blocked) Copy over user group mappings Update new system admin details with old (name, registration date, etc). Copy over Categories: It is recommended to do this via the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
Set ('value','value2',...) String object that can have one or many values of a set of allowed values. 1, 2, 3, 4, or 8 bytes Date/Time Date 'YY-MM-DD', 'YYYY-MM-DD', 'YYMMDD' 3 bytes Range "1000-01-01" to "9999-12-31" Date/Time Time 'HH:MM:SS',...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
1.0.5 - Tested for compatibility with Joomla! CMS v3.4.0 - Included instructions in description - Included license file - Date Uploaded: Thu, 12th Mar 2015 Download 1.0.4 - Tested for compatibility with Joomla! CMS v2.5.8 - Modified description. - Date...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
What? This is a quick article on what should be a simple mathematics equation: Determine the quarter from a given month. Why? Fine if you are determining the quarter by the month and your Fiscal year starts from January, simply divide by 3... How? I'm...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
Source: http://www.kodyaz.com/articles/sql-format-date-format-datetime-t-sql-convert-function.aspx
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
documents how to stop an employee from applying for leave when already 80% of their team have already booked the same date off. My brief was: Check the department this employee belongs to Search for employees of the same department (team members) who...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
Trigger: On button click Purpose: Preps stripe terminal to take payment for balance of invoice. Inputs: invoice Outputs: - Date Created: 2023-02-24 - Initial release - Reads Books Invoice and sends the amount to the reader for a payment atempt Date...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
sid => ? dunno title => by web link title alias => sort by alias title url => sort by url description => sort by description date => sort by date added (most recent or oldest first) hits => sort by hits (number of times clicked on) published =>...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
put a note on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Situation: I have a silly database table (not mine) storing CMIS Facility week numbers and their starting dates. For those of you unfamiliar with this system, the reason week numbers are different to normal people's week numbers is because these are...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
occurred during report processing. Cannot read the next data row for the dataset DataSet1. Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
as compiling it wouldn't be much use to anyone else unless they work for the same company and they're leaving on the same date at the same time. Amend the "FinalDate" value to when you leave, compile the code into an executable, and schedule it as a...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
site using an Agile framework based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week prior to release date). JoelLipman.Com will make the source files available for download 24/7 so...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
]; Solution: My endpoint was the same as a create/add record when it should be suffixed with the ID of the item to update: v_DataEndpoint = "https://inventory.zoho.com/api/v1/items/{item_id}?organization_id=123456789"; r_Response = invokeurl [ url...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module where our client wants to query Zoho Recruit via the API but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
WorkDrive.organization.READ, WorkDrive.teamfolders.ALL, WorkDrive.links.ALL, WorkDrive.DataTemplates.READ Date Created: 2023-12-05 (Joel Lipman) - Initial release - Uploads an image to workdrive and returns the public link Date Modified: ??? - ???...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
users from saving a record without changing this. This script will round up decimal fields onload. Inputs: - Outputs: - Date Created: 2023-12-13 (Joel Lipman) - Initial release - Correctly rounds any decimal fields to their maximum decimal place. Date...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *