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 CRM
- 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 Deluge
- 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 Deluge
- Language: en-GB
-
// 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: *
-
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
-
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: *
-
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 Recruit
- 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 Deluge
- Language: *
-
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
-
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 Deluge
- Language: *
-
{ 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 Projects
- 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: *
-
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: *
-
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
-
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: *
-
the data in that column is not consistent? This made sense as I need to parse the string to extrapolate the date, month and year. How? I used two "Derived Column" tasks for this after giving up with a "Data Conversion" task. I then parse the date, month...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- 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: *