DatePart - Revision history

Ghenne: /* Related Items */

2019-03-25T15:21:51Z

Ghenne at 17:38, 24 March 2019

2019-03-24T17:38:33Z

@@ Line 1: / Line 1: @@
 DatePart(''interval'', ''date''[, ''firstdayofweek''[, ''firstweekofyear'']])
@@ Line 44: / Line 46: @@
 Print "of month " & MonthPart
 Print "in quarter " & QuarterPart
 </pre>

JwellsNB: Add javascript snippet

2013-05-27T00:53:30Z

Add javascript snippet

@@ Line 32: / Line 32: @@
 |}
-== Example ==
+== Example (Basic) ==
 <pre>
 Rem DatePart Example
-'DatePart returns a numberfrompartofadate
+'DatePart returns a number from part of a date
 Dim QuarterPart, MonthPart, DayPart
 QuarterPart = DatePart("q", Now)
@@ Line 44: / Line 44: @@
 Print "of month " & MonthPart
 Print "in quarter " & QuarterPart
 </pre>

Ghenne: /* Description */

2012-12-02T11:42:27Z

Description

← Older revision		Revision as of 11:42, 2 December 2012
Line 4:		Line 4:

	DatePart returns a number specifying a part of the given date. The required parameter, ''interval'', determines the part of date which is measured and returned. The optional parameter ''firstdayofweek'' is Sunday, if not specified The optional ''firstweekofyear'' is the week containing January 1, if not specified.		DatePart returns a number specifying a part of the given date. The required parameter, ''interval'', determines the part of date which is measured and returned. The optional parameter ''firstdayofweek'' is Sunday, if not specified The optional ''firstweekofyear'' is the week containing January 1, if not specified.

			'''Interval Values'''

			{\| class="wikitable"
			\|-
			! Value !! Description
			\|-
			\| yyyy \|\| Year
			\|-
			\| q \|\| Quarter
			\|-
			\| m \|\| Month
			\|-
			\| y \|\| Day of year
			\|-
			\| d \|\| Day
			\|-
			\| w \|\| Weekday
			\|-
			\| ww \|\| Week of year
			\|-
			\| h \|\| Hour
			\|-
			\| n \|\| Minute
			\|-
			\| s \|\| Second
			\|}

	== Example ==		== Example ==

Ghenne: Ghenne moved page Datepart to DatePart

2012-11-06T11:37:41Z

Ghenne moved page Datepart to DatePart

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

Admin: /* Related Items */

2012-09-13T18:30:21Z

Brendon at 00:31, 24 August 2012

2012-08-24T00:31:34Z

← Older revision		Revision as of 00:31, 24 August 2012
Line 8:		Line 8:

	<pre>		<pre>
	~~REM~~ DatePart Example		Rem DatePart Example
	'DatePart returns a numberfrompartofadate		'DatePart returns a numberfrompartofadate
	~~DIM~~ QuarterPart, MonthPart, DayPart		Dim QuarterPart, MonthPart, DayPart
	QuarterPart = DatePart("q", ~~NOW~~)		QuarterPart = DatePart("q", Now)
	MonthPart = DatePart("m", ~~NOW~~)		MonthPart = DatePart("m", Now)
	DayPart = DatePart("d", ~~NOW~~)		DayPart = DatePart("d", Now)
	~~PRINT~~ "Today is day " & DayPart		Print "Today is day " & DayPart
	~~PRINT~~ "of month " & MonthPart		Print "of month " & MonthPart
	~~PRINT~~ "in quarter " & QuarterPart		Print "in quarter " & QuarterPart
	</pre>		</pre>

Line 30:		Line 30:
	== Related Items ==		== Related Items ==

	[[dateadd\|~~DATEADD~~]], [[datediff\|~~DATEDIFF~~]]		[[dateadd\|DateAdd]], [[datediff\|DateDiff]]

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

Brendon at 20:43, 8 August 2012

2012-08-08T20:43:21Z

← Older revision		Revision as of 20:43, 8 August 2012
Line 1:		Line 1:
	~~DATEPART~~(''interval'', ''date''[, ''firstdayofweek''[, ''firstweekofyear'']])		DatePart(''interval'', ''date''[, ''firstdayofweek''[, ''firstweekofyear'']])

	~~'''~~Description~~'''~~		== Description ==

	~~DATEPART~~ returns a number specifying a part of the given date. The required parameter, ''interval'', determines the part of date which is measured and returned. The optional parameter ''firstdayofweek'' is Sunday, if not specified The optional ''firstweekofyear'' is the week containing January 1, if not specified.		DatePart returns a number specifying a part of the given date. The required parameter, ''interval'', determines the part of date which is measured and returned. The optional parameter ''firstdayofweek'' is Sunday, if not specified The optional ''firstweekofyear'' is the week containing January 1, if not specified.

	~~'''~~Example~~'''~~		== Example ==

	<pre>		<pre>
	REM ~~DATEPART~~ Example		REM DatePart Example
	'~~DATEPART~~ returns a numberfrompartofadate		'DatePart returns a numberfrompartofadate
	DIM QuarterPart, MonthPart, DayPart		DIM QuarterPart, MonthPart, DayPart
	QuarterPart = ~~DATEPART~~("q", NOW)		QuarterPart = DatePart("q", NOW)
	MonthPart = ~~DATEPART~~("m", NOW)		MonthPart = DatePart("m", NOW)
	DayPart = ~~DATEPART~~("d", NOW)		DayPart = DatePart("d", NOW)
	PRINT "Today is day " & DayPart		PRINT "Today is day " & DayPart
	PRINT "of month " & MonthPart		PRINT "of month " & MonthPart
Line 19:		Line 19:
	</pre>		</pre>

	~~'''~~Output~~'''~~		== Output ==

	<pre>		<pre>
Line 28:		Line 28:
	</pre>		</pre>

	~~'''~~Related Items~~'''~~		== Related Items ==

	[[dateadd\|DATEADD]], [[datediff\|DATEDIFF]]		[[dateadd\|DATEADD]], [[datediff\|DATEDIFF]]

			[[Category:Language Reference]]

Brendon at 02:45, 4 July 2012

2012-07-04T02:45:36Z

← Older revision		Revision as of 02:45, 4 July 2012
Line 3:		Line 3:
	'''Description'''		'''Description'''

	DATEPART returns a number specifying a part of the given date. The required parameter, interval, determines the part of date which is measured and returned. The optional parameter firstdayofweek is Sunday, if not specified The optional firstweekofyear is the week containing January 1, if not specified.		DATEPART returns a number specifying a part of the given date. The required parameter, ''interval'', determines the part of date which is measured and returned. The optional parameter ''firstdayofweek'' is Sunday, if not specified The optional ''firstweekofyear'' is the week containing January 1, if not specified.

	'''Example'''		'''Example'''

Brendon: Created page with "DATEPART(''interval'', ''date''[, ''firstdayofweek''[, ''firstweekofyear'']]) '''Description''' DATEPART returns a number specifying a part of the given date. The required p..."

2012-07-04T02:44:48Z

Created page with "DATEPART(''interval'', ''date''[, ''firstdayofweek''[, ''firstweekofyear'']]) '''Description''' DATEPART returns a number specifying a part of the given date. The required p..."

New page

DATEPART(''interval'', ''date''[, ''firstdayofweek''[, ''firstweekofyear'']])

'''Description'''

DATEPART returns a number specifying a part of the given date. The required parameter, interval, determines the part of date which is measured and returned. The optional parameter firstdayofweek is Sunday, if not specified The optional firstweekofyear is the week containing January 1, if not specified.

'''Example'''

<pre>
REM DATEPART Example
'DATEPART returns a numberfrompartofadate
DIM QuarterPart, MonthPart, DayPart
QuarterPart = DATEPART("q", NOW)
MonthPart = DATEPART("m", NOW)
DayPart = DATEPART("d", NOW)
PRINT "Today is day " & DayPart
PRINT "of month " & MonthPart
PRINT "in quarter " & QuarterPart
</pre>

'''Output'''

<pre>
Today is day 18
of month 8
in quarter 3
(''sample output from August 18, 1998'')
</pre>

'''Related Items'''

[[dateadd|DATEADD]], [[datediff|DATEDIFF]]

← Older revision		Revision as of 15:21, 25 March 2019
Line 64:		Line 64:

	[[Category:Date and Time]]		[[Category:Date and Time]]

			[[Category:BASIC Functions]]

← Older revision		Revision as of 18:30, 13 September 2012
Line 33:		Line 33:

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

			[[Category:Date and Time]]