DateAdd - Revision history

Ghenne: /* Related Items */

2019-03-25T15:21:07Z

2019-03-24T17:37:55Z

@@ Line 1: / Line 1: @@
 DateAdd(''interval'',''number'',''date'')
@@ Line 39: / Line 41: @@
 Print "+10 seconds:", DateAdd("s", 10, NOW)
 Print "-1 year:", DateAdd("yyyy", -1, NOW)
 </pre>

2013-05-27T17:13:21Z

Example (JavaScript)

← Older revision		Revision as of 17:13, 27 May 2013
Line 67:		Line 67:
	dt.setDate(dt.getDate()+val); break;		dt.setDate(dt.getDate()+val); break;
	case 'ww':		case 'ww':
	dt.setDate(dt.getDate()+(val*7)); break;		dt.setDate(dt.getDate()+((val+1)*7));
			break;
	case 'h':		case 'h':
	dt.setHours(dt.getHours()+val); break;		dt.setHours(dt.getHours()+val); break;
Line 75:		Line 76:
	dt.setSeconds(dt.getSeconds()+val); break;		dt.setSeconds(dt.getSeconds()+val); break;
	}		}
	return dt;		return dispDateTime(dt);
	}		}

	setLastDOM=function(dt,nm) {		setLastDOM=function(dt,nm) {
	while (dt.getMonth() != nm) {		while (nm>11) {nm-=12;}
	dt.setDate(dt.getDate()-1);		while (nm<0) {nm+=12;}
	}		while (dt.getMonth() != nm) {
			dt.setDate(dt.getDate()-1);
			}
			}

			dispDateTime=function(dtm) {
			var tm = dtm.toString();
			var ampm = (tm.toUpperCase().indexOf('AM') > -1) ? ' AM' : ' PM';
			hr = dtm.getHours();
			if (hr < 12) {
			ampm = ' AM';
			} else if (hr > 12) {
			ampm = ' PM';
			hr -= 12;
			if (hr==12) ampm = ' AM'; //midnight
			}
			mn = '0'+dtm.getMinutes();
			mn0 = mn.substr(mn.length-2,2);
			ss = '0'+dtm.getSeconds();
			ss0 = ss.substr(ss.length-2,2);
			tm = hr+':'+mn0+':'+ss0+ampm;
			return dt.getMonth()+1+'/'+dt.getDate()+'/'+dt.getFullYear()+' '+tm;
	}		}

2013-05-26T21:21:40Z

← Older revision		Revision as of 21:21, 26 May 2013
Line 86:		Line 86:
	var dt = new Date();		var dt = new Date();
	NSB.Print('+10 seconds: ' + dt.DateAdd('s', 10));		NSB.Print('+10 seconds: ' + dt.DateAdd('s', 10));
	NSB.Print('~~add~~ 1: ' + dt.DateAdd('ww', 1));		NSB.Print('-1 year:' + dt.DateAdd('yyyy', -1));
	</pre>		</pre>

2013-05-26T21:18:42Z

Example (JavaScript)

2013-05-26T21:00:24Z

Add javascript snippet

@@ Line 32: / Line 32: @@
 |}
-== Example ==
+== Example (Basic) ==
 <pre>
@@ Line 39: / Line 39: @@
 Print "+10 seconds:", DateAdd("s", 10, NOW)
 Print "-1 year:", DateAdd("yyyy", -1, NOW)
 </pre>

2012-12-02T11:42:10Z

Description

← Older revision		Revision as of 11:42, 2 December 2012
Line 3:		Line 3:
	== Description ==		== Description ==

	DateAdd returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add, see ~~Table 6~~ below. The required parameter, ''number'', is any numeric expression that specifies the number of intervals to add.The required parameter, ''date'', can be any expression that represents a date.		DateAdd returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add: see table below. The required parameter, ''number'', is any numeric expression that specifies the number of intervals to add.The required parameter, ''date'', can be any expression that represents a date.

	'''Interval Values'''		'''Interval Values'''

2012-12-02T11:41:33Z

Description

← Older revision		Revision as of 11:41, 2 December 2012
Line 5:		Line 5:
	DateAdd returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add, see Table 6 below. The required parameter, ''number'', is any numeric expression that specifies the number of intervals to add.The required parameter, ''date'', can be any expression that represents a date.		DateAdd returns the date which is obtained by adding a specified number of date intervals to a given date. The required parameter, interval, is a string expression that specifies the type of date interval to add, see Table 6 below. The required parameter, ''number'', is any numeric expression that specifies the number of intervals to add.The required parameter, ''date'', can be any expression that represents a date.

	'''~~Table 6:~~ Interval Values'''		'''Interval Values'''

	{\| class="wikitable"		{\| class="wikitable"

2012-11-06T11:36:43Z

Ghenne moved page Dateadd to DateAdd

← Older revision		Revision as of 11:36, 6 November 2012
(No difference)

2012-09-13T18:29:48Z

← Older revision		Revision as of 18:29, 13 September 2012
Line 53:		Line 53:

	[[Category:Language Reference]]		[[Category:Language Reference]]

			[[Category:Date and Time]]