Assuming days is required, the following 51 results were found.
-
WHERE YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' ) AS 'Total Days' FROM StaffActivities s WHERE s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION' "; // POST-NOTES: // 26640 is 7 hours 24...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
lets you click on "Ok"). Initially I got a support agent from GoDaddy to do this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working. I followed the process above...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
What we want The user will select a date. We want the report to open with the specified day expanded and the remaining days that week to be collapsed (hidden). The first time I did this, I couldn't expand the remaining days so don't forget to tick the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
and comfort in the working environment." So it's pretty important not to be slouching over the coffee table for hours or days on end. I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
format Sat 01-Jan-2011 01:00:00 The next function usually accompanies the above one. It will basically convert seconds into days, hours, minutes, etc.: FormatSeconds(val) { IfInString, val, - { Month:=SubStr(val, 8, 3) Month:=Month * 1...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
can sometimes confuse the program) Rant It's flimsy, crude but does what it has to do. The program itself took only about 6 days to make, it was a quick solution to a service that could not be obtained for free or without a lot of work (setting up my...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
when registering for username reminders, password resets, or e-mail changes. The key stored on the device expires after 30 days and requires you to login again if you have not used this app in that time. ChangeLog v1.8.x [25 Nov 2014] - [1.8.5] Hangar:...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
(all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = "Credit Note - 30 Days"; // we want the 30 from the above string How? I'm aware of the getAlphaNumeric() function in Zoho and I can remove the letters...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the department this employee belongs to Search for employees of the same department (team members) who have booked the same days off (ie count holiday clashes) Prevent an employee for applying for leave if over 80% of the department have already booked...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums and documentation, I found a solution which worked for me. Note that...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
it. You will find issues with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the days of getting an MS Word document to behave?). Best thing to do if you mess it up, is just start again with a clone of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
An article on something that has taken me several days to get working: Get Zoho Books or Zoho Inventory that when an invoice is marked as paid, update 2 custom fields with the Payment Method, and the Payment Date. Why? This was requested by a customer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Icon) > Automation > Schedules > New Schedule > I'm calling mine Nightly Schedule To Update Shipment Status // // init v_DaysAgo = 2; v_BooksOrgID = organization.get("organization_id"); // // specify DHL API Key (no need for the secret) v_DHL_API_Key =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Time is greater than yesterday's date (today) Use URL of the image representing OK Else If Modified Time is greater than 5 days ago Use URL of the image representing Warning Else Use URL of image representing a FAILURE ***/ But if I want it to join to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
documents it but as this is a fair bit of coding, you may want to ask us to build this solution for you. It can take a few days but it will save your staff a ton of time per week! What your staff see: How? So we're going to create a button. Let's use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
There's documentation out there but as this took me a couple of days to simply install a JS widget hosted by Zoho and pass the record ID via a button to it, I'm adding it here in case I need to refer to it in future. Why? We have an Accounts module...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
If asked: "how long will it take", do not say 5 minutes. This script runs on average in 15 seconds. The remaining hours, days, weeks will be spent on bringing your website up to standard with all issues addressed and sporting the latest version of the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
to create a dropdown which selects all projects associated with a particular user. Method #1: Important! It took me two days to realize that underscores are not accepted in the type name (despite copying "custom_field.php" and wanting to call my type...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
At least this article should have got you to the part where you're simply specifying what data displays where. It took me 4 days to figure this out then document it. Here's to hoping that this saves you some time!
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
than 100 rows, it would complete in under 10 seconds (7.5 seconds). We played with hardware memory, report layouts and a few days worth of other solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB