Assuming year is required, the following 49 results were found.
-
fields we need to refer to var v_OppType = r_DealDetails.Type_of_Opportunity; var v_DealRate0 = r_DealDetails.Rate_Year_1_0; var v_DealRate1 = r_DealDetails.Rate_Year_1_5; var v_DealRate2 = r_DealDetails.Rate_Year_2_0; var v_DealRate3 =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(v_CheckDateEnd.toString("E")=="Sun") { v_DST_EndTime = v_CheckDateEnd; } } info "Start Date (Current Year): " + v_DST_StartTime.toString("EEEE, yyyy-MM-dd HH:mm"); info "End Date (Current Year): " + v_DST_EndTime.toString("EEEE, yyyy-MM-dd HH:mm");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
by month. Also associates a UserID to the wikimedia_user table to identify a user. SELECT CONCAT(MONTHNAME(t2.Date), ' ', YEAR(t2.Date)) Month, SUM(IF(t2.VisitorType='Staff', 1, 0)) Staff, SUM(IF(t2.VisitorType='Student', 1, 0)) Student,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
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 showing this in Zoho Deluge but the logic can be adapted to other code. You will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: en-GB
-
SSRS / MDX Date Querieshttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-mdx-date-queries.html
// yields: 8/1/2011 -- End Date (US format - mm/dd/yyyy) =DateAdd("d",-1, CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) ) // yields: 8/31/2011 ------------------------------------------------------------------------- -- Start Date...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month (dd) 4 %j day of year, zero padded 001-366 %u day of week starting with Monday (1), i.e. mtwtfss 1 %w day of week starting with Sunday (0), i.e. smtwtfs...
- Type: Article
- Author: Joel Lipman
- Category: Linux
- Language: *
-
Source: http://en.wikipedia.org/wiki/Comparison_of_web_browsers Year Web Browsers Internet Users (in millions) 1991 WorldWideWeb 1992 ViolaWWW, Erwise, MidasWWW, MacWWW 1993 Mosaic, Cello, Lynx 2.0, Arena, AMosaic 1.0 1994 IBM WebExplorer, Netscape...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count all accounts irrespective of being activated or not). It needs to pick up trends as well and compare...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
the developer wrote a system he felt would last the rest of his PhD degree, it's a shame he started in his last year. He used functions to mktime and simulate the dates. A function goes in with a normal calendar date and returns an academic week number...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
as opposed to calendar week numbers. Why? The aim of this article is to quickly generate a calendar for a full academic year for referencing by staff/students. How? Let us assume that we have a system holding a calendar in the following table (called...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
in ZohoRecruit. How? As mentioned, we're going to update several fields called: Number of Candidates This Graduation Year Number of Candidates Next Graduation Year Candidates Graduated in the Past Candidates Graduating in the Future Total Number of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a Sunday but in the United Kingdom, the week generally starts on a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see article link above), we're going to use...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
returned a data type that is not valid. My DataSet Query was as follows: SELECT CONCAT(MONTHNAME(t1.Date), ' ', YEAR(t1.Date)) Month, SUM(IF(t1.VisitorBrowser='MSIE', 1, 0)) 'IE', SUM(IF(t1.VisitorBrowser='Firefox', 1, 0)) 'FF',...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
PHP & MySQL it's pretty simple: use individual SQL queries to get the count of yesterday, yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- 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
-
{ l_ThisDateEventParts = l_ThisDateTimeEventParts.get(0).toList("/"); v_ThisDateEvent_Year = l_ThisDateEventParts.get(2); v_ThisDateEvent_Month = l_ThisDateEventParts.get(1); v_ThisDateEvent_Day = l_ThisDateEventParts.get(0); l_ThisTimeEventParts =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
and to date respectively: -- From Date (european format - dd/mm/yyyy) =CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now()))) -- To Date (european format - dd/mm/yyyy) =dateadd("d",-1, CDate("01/" + cstr(month(today.now())+1) + "/" +...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
' - ', r.ResourceName) AS Resource, s.StaffActivity AS Activity, s.AdditionalNotes AS Notes, CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek, CASE COUNT(*) WHEN 1 THEN '(1...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
DECLARE @OrigLen int; DECLARE @CurrLen int; DECLARE @LoopCt int; DECLARE @Rand int; -- for dates/times DECLARE @MinYear int; DECLARE @MaxYear int; DECLARE @RandYear int; DECLARE @RandMonth int; DECLARE @RandDay int; DECLARE @RandHour int; DECLARE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF