DZone Snippets: month code

Increment a date using Ruby

jrobertson (James Robertson) — Wed, 05 Mar 2008 13:43:34 GMT

This Ruby code converts a string into a date and increments the day, week, month, quarter or year.



def date_add(sdate='', unit='',i=0)



  sdate[/(\d+)\/(\d+)\/(\d+)\s(\d+):(\d+):(\d+)/]

  iyear = $3.to_i; imonth = $2.to_i; iday = $1.to_i; ihour = $4.to_i; imin = $5.to_i; isec = $6.to_i

  

  case  unit

    when 'days'

      t1 = Time.local(iyear,imonth,iday,ihour,imin,isec)

      t1 += (60 * 60 * 24 * i)

    when 'weeks'

      t1 = Time.local(iyear,imonth,iday,ihour,imin,isec)

      t1 += (60 * 60 * 24 * 7 * i) 

    when 'months'

      imonth += i

      if imonth < 12 then

        t1 = Time.local(iyear,imonth+i,iday,ihour,imin,isec)

      else

        t1 = Time.local(iyear+=1,imonth -12,iday,ihour,imin,isec)

      end

    when 'quarter'

      imonth += 3

      if imonth <= 12 then

        t1 = Time.local(iyear,imonth,iday,ihour,imin,isec)

      else

        t1 = Time.local(iyear+=1,imonth - 12,iday,ihour,imin,isec)

      end    

    when 'years'

      t1 = Time.local(iyear+i,imonth,iday,ihour,imin,isec)

    else

      raise 'not a valid date unit'

  end

  t1

end



date_add("17/03/2008 17:48:00",'months',2)

output: Sat May 17 17:48:00 +0100 2008

Code to disable YUI calendar previous and next month links icons

robd (Rob Dupuis) — Mon, 03 Mar 2008 20:57:33 GMT

This solution does not require modifying the yui source and works on YUI version 2.5.0. It will disable the next and previous arrows based on the out of bounds dates you specify with mindate and maxdate when you configure the calendar. Requires YUI dom and a namespace called your_app.

1) attach an onRender event when you configure the calendar and before you call render

calendar.renderEvent.subscribe(YAHOO.your_app.calendar().initArrows, calendar);

2) add the following function:



YAHOO.your_app.calendar = function() {

	

	var addDays = function(date, days) {

		return YAHOO.widget.DateMath.add(date, YAHOO.widget.DateMath.DAY, days);

	};

	

	var showPreviousArrow = function(cal) {

		return showArrow(cal, cal.toDate(cal.cellDates[0]), 1);

	};



	var showNextArrow = function(cal) {

		return showArrow(cal, cal.toDate(cal.cellDates[cal.cellDates.length-1]), -1);

	};

	

	var showArrow = function(cal, startingDate, step) {

		if (!cal.isDateOOM(startingDate)) { //ie not overlapping

			return !cal.isDateOOB(addDays(startingDate, (-1 * step)));

		}

		for (var i=0; (i * step) < 7; i += step) { //iterate forwards for previous month check, backwards for next month check

			var date = addDays(startingDate, i);

			if (!cal.isDateOOM(date)) { //shortcut exit; as soon as we find an in month date we can supress the arrow

				return false;

			} else if (!cal.isDateOOB(date)) {

				return true;

			}

		}

		return false;

	};

	

	return {

		initArrows: function(type, args, cal) {

			if (!showPreviousArrow(cal)) {

				hideArrow(cal, cal.Style.CSS_NAV_LEFT);

			}



			if (!showNextArrow(cal)) {

				hideArrow(cal, cal.Style.CSS_NAV_RIGHT);

			}

		}

	};

};

Calculate last day of current Month

bmowbray (Brian Mowbray) — Wed, 27 Feb 2008 19:13:47 GMT

'Determines what the next month is based on today and subtracts 1 day from first day of next month.



'VB.NET

Dim NextMonth As Integer

Dim RptYear As Integer

'Determine next month

NextMonth = DatePart(DateInterval.Month, DateAdd(DateInterval.Month, +1, today))

'Determine the year of the next month, in case you are going from Dec to Jan

RptYear = DatePart(DateInterval.Year, DateAdd(DateInterval.Month, +1, today))

'Subtract 1 day from the first day of next month to get this months last day

Return DateAdd(DateInterval.Day, -1, DateValue(NextMonth.ToString & "/1/" & RptYear.ToString))

Formatting a date in XSLT

jrobertson (James Robertson) — Fri, 08 Feb 2008 00:00:30 GMT

This template formats a date ie 060208171320 -> 06-Feb-08T17:13:20

copied from http://snipr.com/1z833 [geekswithblogs.net] and modified to suit the date input format I used.

PHP : Obtener registros por mes

Ricardo (Ricardo m. García) — Thu, 13 Sep 2007 12:08:26 GMT

si tienes un campo de tipo time() y necesitas sacar los registros de un determinado mes.



$mes=2;//febrero

$strquery="SELECT *

FROM `tabla`

WHERE month( from_unixtime( fecha ) ) = '$mes'";

?>

days in month

kelyar (Kelyarsky Evgeniy) — Tue, 07 Aug 2007 13:10:38 GMT

// returns number of days in specified month



def days_in_month(month)

  (Date.new(Time.now.year,12,31).to_date<<(12-month)).day

end

Determining the Number of Days in a Month with Javascript

Charlie (Stephen Martindale) — Thu, 25 May 2006 12:02:48 GMT

Essentially, writing some code to determine the number of days in a given month of a given year with javascript is not the worlds most difficult task. It is the type of exercise that one would expect to be given as a newbie developer during a lab or lecture. The solution normally involves determining if the month is February, an month with 30 days or a month with 31 days, then (if February) checking if the year is a leap year. All these tests add up, however, and add several lines of code to your .js file. They are also unnecessary!

Apparently, the javascript Date function allows you to overflow the day number parameter that you pass, creating a date in the next month. Deliberately overflowing the day parameter and checking how far the resulting date overlaps into the next month is a quick way to tell how many days there were in the queried month. Here is a function that does this:



function daysInMonth(iMonth, iYear)

{

	return 32 - new Date(iYear, iMonth, 32).getDate();

}

N.B.: iMonth is zero based, so 0 represents January, 1 represents February, 2 represents March and 11 represents December. iYear is not zero based, this is the actual calendar year number. (2006 is actually 2006)

Pray that the browser developers know the correct way to determine whether a year is a leap year! (It's more complicated than a simple mod 4 == 0) Here is a quote from Wikipedia's page on leap years: "The Gregorian calendar, the current standard calendar in most of the world, adds a 29th day to February in all years evenly divisible by 4, except for centennial years (those ending in '00'), which receive the extra day only if they are evenly divisible by 400. Thus 1600, 2000 and 2400 are leap years but 1700, 1800, 1900 and 2100 are not."

To test this function, February in the years 2100, 2005, 2004, 2003, 2001, 2000 and 1999 should be checked. All of these should return 28, except for 2004 and 2000.

How does this function work? It is quite simple. When the Date() function is given a day number that is greater than the number of days in the given month of the given year, it wraps the date into the next month. The getDate() function returns the day of the month, starting from the beginning of the month that the date is in. So, day 32 of March is considered to be day 1 of April. Subtracting 1 from 32 gives the correct number of days in March!

DateTime: Simple date operations in javascript

drefty (drefty) — Fri, 02 Dec 2005 07:17:12 GMT



/*

### begin_: file metadata

    ### 

    ### main:

    ###   - name : cfDateTime.js

    ###     desc : |

    ###         Simple date operations in jscript.

    ###         This file is for use with windows scripting host.

    ###     date : created="Thu 2005-12-01 11:57:38"

    ###     last : lastmod="Thu 2005-12-01 12:18:57"

    ###     lang : jscript

    ###     tags : jscript javascript date time now month hour year cfDateTime

    ### 

    */



/// begin_: declare and init variables

    var today       = new Date();

    var strYear     = today.getFullYear();

    var iMonth      = today.getMonth() + 1; // +1, we do NOT want zero-based month index

    var iQuarter    = Math.ceil((iMonth / 12) * 4);

    var iDay        = today.getDate();

    var strDateOut  = "";



/// begin_: leading zeropad single-digit numbers

    iMonth = (iMonth < 10)? "0" + iMonth : iMonth;

    iDay = (iDay < 10)? "0" + iDay : iDay;



/// begin_: display output

    strDateOut = strYear+"-"+ iMonth +"-"+iDay + " ";

    WScript.Echo (strDateOut);

DateTime: generic date and time script in perl

drefty (drefty) — Fri, 02 Dec 2005 05:27:40 GMT



### begin_: file metadata

    ### 

    ### main:

    ###   - name : DateTime.pl

    ###     desc : DateTime: generic date and time script in perl

    ###     date : created="Thu 2005-12-01 10:04:52"

    ###     last : lastmod="Thu 2005-12-01 10:04:59"

    ### 



### begin_: initialize perl (optional)

    use strict;

    use warnings;



### begin_: initialize DateTime values

    my %dttime = ();

    my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time);



### begin_: initialize DateTime number formats

    $dttime{year }  = sprintf "%04d",($year + 1900);  ## four digits to specify the year

    $dttime{mon  }  = sprintf "%02d",($mon + 1);      ## zeropad months

    $dttime{mday }  = sprintf "%02d",$mday;           ## zeropad day of the month

    $dttime{wday }  = sprintf "%02d",$wday + 1;       ## zeropad day of week; sunday = 1;

    $dttime{yday }  = sprintf "%02d",$yday;           ## zeropad nth day of the year

    $dttime{hour }  = sprintf "%02d",$hour;           ## zeropad hour

    $dttime{min  }  = sprintf "%02d",$min;            ## zeropad minutes

    $dttime{sec  }  = sprintf "%02d",$sec;            ## zeropad seconds

    $dttime{isdst}  = $isdst;



### begin_: xnpDate print iso8601 version date

    print "$dttime{year}-$dttime{mon}-$dttime{mday}\n";



### begin_: xnpNow show system time

    print "$dttime{year}-$dttime{mon}-$dttime{mday} $dttime{hour}:$dttime{min}:$dttime{sec} \n";