Assuming dates is required, the following 37 results were found.
-
https://www.joellipman.com/articles/crm/zoho/zoho-creator-push-to-ebay-listings.html */ // // evaluate (specify here your dates [time set to midnight]) v_timeFrom = zoho.currenttime.subDay(0).toString("yyyy-MM-dd'T'00:00:00.000'Z'"); v_timeTill =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
case Zoho Inventory. So for this, I've set up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: Login to ZohoInventory > Setup (Cog Icon) > Automation > Schedules...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I often need to send through an automatic payment term on the creation of an invoice but lots of my clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
v_ContactNumber = ifnull(r_ContactDetails.get("Mobile"),r_ContactDetails.get("Phone")); } // // ---------------------- QUOTE DATES ---------------------- m_CreateEstimate.put("date",r_QuoteDetails.get("Created_Time").subString(0,10));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Outputs: - 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Xero and pull 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: *
-
ON CONVERT(VARCHAR(8) , t.Time, 108) BETWEEN e.EventStart AND DATEADD(minute, -1, e.EventFinish) --Set the maximum times the Dates cte can recurse OPTION (MAXRECURSION 100) 1. Create a new report: We're going to run the wizard here but without it just...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
to the calendar quite easily as we used to use an Outlook Shared Calendar before. We see leave announcements as well as key dates and deadlines popup which a single user assigned as "calendar manager" may have missed. Not automated? No but far more...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
string,start,length ) 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...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
an empty row. My final query This displays all room bookings for today and the next 6 days. Note how I can't use normal dates because the database wasn't designed with timestamps (despite being a timetabling and room booking system). But I do get given...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
smart function which could determine the datatype automatically but as you may know, Oracle has a funny way of working with dates which made this need to be changed. The following function now requires a second parameter where you specify the data type:...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
to the "Report Filter" section Alternative option... still in progress... Create two cells with the default from and to dates: The formula for the first date of this week was =DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-WEEKDAY(TODAY())+2) Note the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
uses the current date in the form of NOW() but this example has to work with any given date. First of all: Get this week's dates and days: SELECT DATE( DATE_ADD( NOW( ) , INTERVAL 0 - WEEKDAY( NOW() ) DAY ) ) AS ThisDate, DAYNAME( DATE_ADD( NOW( ) ,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
...specific... / Random. - Parameters: Module Width / Height / Font-size Override. - Parameters: Show Descriptions / Images/ Dates / Hits. - Parameters: Get Titles + Descriptions (Local / Remote) - Parameters: CSS3 Text Effects - rotate, shadow,...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot and note the dates for Monday, Tuesday, Wednesday, and Thursday: Note how amusingly Microsoft thinks Wednesdays come before Mondays... but...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
the server or the client machine. Realised that this was actually specified in the report. Here's a quick note on how to set Dates and Times used in parameter fields to UK format (dd/MM/yyyy). You can override this in the report by: Go to Design Select...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the date in an IIF (if-then-else) statement displays "#Error". You should get errors referring to converting strings to dates and incorrect data types. How? The fix is to simply get the field and both results to be of the same data type:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB