Assuming days is required, the following 50 results were found.
-
A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
report is a pivot table with staff members along the top, tasks down the first column, and time spent in the form of person days in the cross-join. Why? Currently the smallest bookable time by low-level tape monkeys and techies is 30 minutes (Managers...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
type: GET connection: "mycrmconnection" ]; info r_OrgDetails; Yields something like { "business_hours": { "business_days": [ "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday" ], "custom_timing": [ { "days": "Monday", "business_timing":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
up when a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to a specified user". Why? Sorry Zoho! I tried using the interface to set up a workflow or any other mechanisms...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
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
- Language: *
-
Forum Ruleshttps://joellipman.com/static-items/forum-rules.html
a permanent ban: Warning - Depending on how serious a violation is, you may be issued a warning first Muting - Muting for 10 days Temporary ban - People who cause more problems after being muted for 10 days will be banned for a month, and for 2 months...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
to: Microsoft Windows 7 Enterprise AutoHotkey (see code for AHK version) What? Someone suggested an app that counts the days I have left serving my notice. I thought I'd go one better and have it calculate to the nearest second. I call this latest app...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which employee, on what date, and for how many days they were off sick. When...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days and time slots must be listed irrespective of whether any time has...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which copies it to the remaining working days. How? So I have a form with 6 subforms which list...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a style that was hard to customize. Remository Really liked this and used for the best of 2 years. But 1000 downloads in 10 days caused it to crash my Joomla! website. It was very plain and basic, needed tweaking to get rid of adverts and to integrate...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
is either empty or says "Separator Marker". Based on the CTE above, I now need to add an actual row separating the different days which is either blank or full of hyphens/dashes. Stage #2: Replace values in last data row with blanks The trick to this is...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
/MIN:n :: MINimum file size - exclude files smaller than n bytes. /MAXAGE:n :: MAXimum file AGE - exclude files older than n days/date. /MINAGE:n :: MINimum file AGE - exclude files newer than n days/date. /MAXLAD:n :: MAXimum Last Access Date - exclude...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
" F" htmlText:=htmlText " S" htmlText:=htmlText " S" htmlText:=htmlText " " htmlText:=htmlText "" ; GET NUMBER OF DAYS THIS MONTH ; Haven't found anyone who calculates how many days there are in a month so this is a crude solution ; This checks if this...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
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
-
as 'DATE'; v_rand_param1 := TO_CHAR(TO_DATE(v_rand_param1,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. from 01/01/1901 (Julian Days) v_rand_param2 := TO_CHAR(TO_DATE(v_rand_param2,'dd/mm/yyyy hh24:mi:ss'),'J'); -- eg. to 01/01/2001 (Julian Days) v_returnedval...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
and (b) permanently, if the copyright holder fails to notify you of the violation by some reasonable means prior to 60 days after the cessation. Moreover, your license from a particular copyright holder is reinstated permanently if the copyright holder...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
for Joomla (JIJ) need? Summary Period Report (details on your awstats report) Monthly History (per month per year) Days of Month (per day this month) Days of Week (per day this month) Hours (per hour this month) Countries (Top 25 this month) Hosts (Top...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *