Assuming time is required, the following 230 results were found.
-
This is an article to document how I got a client's eBay to notify the seller every time a buyer bought a fixed price item. This uses the Trading API even though I'm aiming for the Platform Notifications API... Why? A follow on from my article Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
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', 'HHMMSS', 'HHMM', 'HH' 3 bytes...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
my build. Although not high budget like lots of YouTubers I drew inspiration and advice from, it's my first build in a long time. It's always been a dream of mine (see my pinterest) to build a nicer looking computer and I was given £1000 towards a new...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
the board. You may still view it. Temporary Ban - This is where you are not able to view the board for a certain period of time. Permanent Ban - You can never again view the board. The following rules list the most serious violations: No Hacking - This...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
services. There are websites that do this for me? Yay! for free as well, as long as my page isn't loaded more than 100,000 times a month. I don't understand, one website visitor can generate 1000 hits, so thereafter I have to pay every time someone sees...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- 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: *
-
to be based on the pull from invoices article I wrote earlier but with quotes from Xero, things panned out differently: Date/Time values don't include a timezone Issues with tax rates meant replicating a tax list copy from Xero to Zoho the Client...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
It is taken from Google's documentation as well as other forums and websites that try to explain it. Do not waste your time like I did on the public key, verifying a JWT signature, or including any third-party libraries. You can do it in pure PHP and...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
using the ReportServer database in SSRS 2008 R2: SELECT Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun, DATEPART(week, ExecutionLogStorage.TimeStart) AS WeekRun, DATEPART(year,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
) 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 MONTHNAME(now())...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
So I'm starting to get the impression that I no longer tender for brand new projects competing with time and cost in order to win the bids. Recently, more and more people have been asking if I can take over a project that has been abandoned by its...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
find myself again the dummie of the Internet. I basically came across this error and STFW'd for ages following complex T-SQL Timestamp conversions but to no avail. Not saying that you shouldn't try their solutions but just check you haven't done this...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
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 windows task for...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
is reinstated permanently if the copyright holder notifies you of the violation by some reasonable means, this is the first time you have received notice of violation of this License (for any work) from that copyright holder, and you cure the violation...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
is something that can emulate a random number... well it's not really random, it involves getting the milliseconds from a time object. v_Uid = zoho.currenttime.toLong(); // returns something like 1557400230165 Method #1: 5 Randomly Selected Letters...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
node into a map: info m_Response.get("item").toMap().get("item_id"); // yields: 123456789012345678 Problem: Inserting a date time string into a date time field in Deluge So annoying but sometimes you want to insert a date/time value into a date/time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
which includes the Bootstrap and jQuery frameworks as well as other JavaScript functionality. Why? Quite simply that at time of print (2020-10-24), Zoho Creator does not allow you to use JavaScript anywhere in its app. HTML and CSS are mostly allowed...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently introduced the ability to have custom fields in your line items, alongside the product name,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
processing the same record twice. Why? Whether you have a few hundred records, or a few hundred thousand records, we sometimes want to write a function that will check each record and mark it so that the process doesn't repeat on records that have...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *