Days - Revision history

Gordon.dye at 17:16, 18 February 2026

2026-02-18T17:16:53Z

← Older revision		Revision as of 17:16, 18 February 2026
Line 1:		Line 1:
	DAYS (<date>[,<format$>])		DAYS (<date>[,<format$>])

	'''DAYS''' [[internal function]] returns the absolute, sequential value which is assigned to dates ~~after~~ January 1, 1900.		'''DAYS''' [[internal function]] returns the absolute, sequential value which is assigned to dates beginning January 1, 1900.

	BaseYear is used to determine the century for a date if the format specification used does not specify a century. See [[BaseYear]] in the [[BRConfig.sys]] specifications section for complete information.		BaseYear is used to determine the century for a date if the format specification used does not specify a century. See [[BaseYear]] in the [[BRConfig.sys]] specifications section for complete information.

Gordon.dye: /* Handling Input */

2019-04-05T13:45:55Z

Handling Input

← Older revision		Revision as of 13:45, 5 April 2019
Line 77:		Line 77:
	Notes:		Notes:
	* When using H:M:S, the time Component must be HH:MM:SS, so for example 3:10:57 PM will not work properly		* When using H:M:S, the time Component must be HH:MM:SS, so for example 3:10:57 PM will not work properly
	* In the above example, PM was provided, but the results are reflecting AM, this suggests that BR 4.31ga does not respect the AM/PM indicator
	* When providing a time without a date, the function will return the days value for the 1st day of THIS month. In the Above examples, the date was 7/13/15		* When providing a time without a date, the function will return the days value for the 1st day of THIS month. In the Above examples, the date was 7/13/15
	* When using H#.#### the Hours must be 2 Digits "03" not "3", and the # of decimals must at least match the mask provided.		* When using H#.#### the Hours must be 2 Digits "03" not "3", and the # of decimals must at least match the mask provided.

GomezL: /* Handling Input */

2015-07-14T14:04:14Z

Handling Input

← Older revision		Revision as of 14:04, 14 July 2015
Line 72:		Line 72:

	Examples:		Examples:
	DAYS("7/13/15 03:10:57 PM","M/D/Y H:M:S") -> 42197.1326042		DAYS("7/13/15 03:10:57 AM","M/D/Y H:M:S AM") -> 42197.1326042
	DAYS("03:10:57 PM","H:M:S") -> 42185.1326042		DAYS("03:10:57 AM","H:M:S AM") -> 42185.1326042
	DAYS("7/13/15 03.1825","M/D/Y H#.####") -> 42197.1326042		DAYS("7/13/15 03.1825","M/D/Y H#.####") -> 42197.1326042
	Notes:		Notes:

GomezL: /* Handling Input */

2015-07-14T08:11:21Z

Handling Input

← Older revision		Revision as of 08:11, 14 July 2015
Line 72:		Line 72:

	Examples:		Examples:
	DAYS("7/13/15 03:10:57 PM ~~EDT~~","M/D/Y H:M:S") -> 42197.1326042		DAYS("7/13/15 03:10:57 PM","M/D/Y H:M:S") -> 42197.1326042
	DAYS("03:10:57 PM ~~EDT~~","H:M:S") -> 42185.1326042		DAYS("03:10:57 PM","H:M:S") -> 42185.1326042
			DAYS("7/13/15 03.1825","M/D/Y H#.####") -> 42197.1326042
	Notes:		Notes:
	* When using H:M:S, the time Component must be HH:MM:SS, so for example 3:10:57 PM will not work properly		* When using H:M:S, the time Component must be HH:MM:SS, so for example 3:10:57 PM will not work properly
			* In the above example, PM was provided, but the results are reflecting AM, this suggests that BR 4.31ga does not respect the AM/PM indicator
	* When providing a time without a date, the function will return the days value for the 1st day of THIS month. In the Above examples, the date was 7/13/15		* When providing a time without a date, the function will return the days value for the 1st day of THIS month. In the Above examples, the date was 7/13/15
			* When using H#.#### the Hours must be 2 Digits "03" not "3", and the # of decimals must at least match the mask provided.

	===Saving Dates===		===Saving Dates===

GomezL: /* Handling Input */

2015-07-14T07:52:11Z

Handling Input

← Older revision		Revision as of 07:52, 14 July 2015
Line 70:		Line 70:
	The absence of AM and PM denote military hours (0 – 23).		The absence of AM and PM denote military hours (0 – 23).
	The maximum significant digits that can be represented in a numeric variable are 15. So if century, year, month and day are stored as a 5 digit day of century, then internally up to ten digits to the right of the decimal are available for time of day.		The maximum significant digits that can be represented in a numeric variable are 15. So if century, year, month and day are stored as a 5 digit day of century, then internally up to ten digits to the right of the decimal are available for time of day.

			Examples:
			DAYS("7/13/15 03:10:57 PM EDT","M/D/Y H:M:S") -> 42197.1326042
			DAYS("03:10:57 PM EDT","H:M:S") -> 42185.1326042

			Notes:
			* When using H:M:S, the time Component must be HH:MM:SS, so for example 3:10:57 PM will not work properly
			* When providing a time without a date, the function will return the days value for the 1st day of THIS month. In the Above examples, the date was 7/13/15

	===Saving Dates===		===Saving Dates===

Laura: /* Handling Input */

2014-09-22T20:35:17Z

Handling Input

← Older revision		Revision as of 20:35, 22 September 2014
Line 47:		Line 47:
	* Any valid format for month or day is accepted on input where the mask requests the respective month or day.		* Any valid format for month or day is accepted on input where the mask requests the respective month or day.
	* Any valid separator will be accepted where any separator is specified by the mask.		* Any valid separator will be accepted where any separator is specified by the mask.

			Otherwise, BR requires that the entered value conform to the specified mask to
			avoid the entry of incorrect dates using unforeseen valid expressions.

	Examples:		Examples:
Line 57:		Line 60:
	days("23 Jan;",'dd m3,') -> 40200 (current year and century)		days("23 Jan;",'dd m3,') -> 40200 (current year and century)

	~~BR requires that the entered value conform to the specified mask to~~		BR allows a null mask, but the omission of a mask does not denote a null mask. It denotes whatever the system default mask is currently set to, which could be the system default.
	~~avoid the entry of incorrect dates using unforeseen valid expressions.~~ BR allows a null mask, but the omission of a mask does not denote a null mask. It denotes whatever the system default mask is currently set to, which could be the system default.

	*As of 4.3, numeric variables can now represent time of day in the fractional space (to the right of the decimal point) to include the following:		*As of 4.3, numeric variables can now represent time of day in the fractional space (to the right of the decimal point) to include the following:

Laura: /* Handling Input */

2014-09-22T20:33:48Z

Handling Input

← Older revision		Revision as of 20:33, 22 September 2014
Line 43:		Line 43:

	===Handling Input===		===Handling Input===
	BR does not require that the entered value conform to the specified mask to avoid the entry of incorrect dates using unforeseen valid expressions. If a date format mask omits month, day, year and/or century, BR ~~now~~ assumes the first day of the current month for the respective omitted mask components. Values must conform to masks with the following exceptions:		(4.2+) BR does not require that the entered value conform to the specified mask to avoid the entry of incorrect dates using unforeseen valid expressions. If a date format mask omits month, day, year and/or century, BR assumes the first day of the current month for the respective omitted mask components. Values must conform to masks with the following exceptions:

	* Any valid format for month or day is accepted on input where the mask requests the respective month or day.		* Any valid format for month or day is accepted on input where the mask requests the respective month or day.
Line 57:		Line 57:
	days("23 Jan;",'dd m3,') -> 40200 (current year and century)		days("23 Jan;",'dd m3,') -> 40200 (current year and century)

	BR allows a null mask, but the omission of a mask does not denote a null mask. It denotes whatever the system default mask is currently set to, which could be the system default.		BR requires that the entered value conform to the specified mask to
			avoid the entry of incorrect dates using unforeseen valid expressions. BR allows a null mask, but the omission of a mask does not denote a null mask. It denotes whatever the system default mask is currently set to, which could be the system default.

	*As of 4.3, numeric variables can now represent time of day in the fractional space (to the right of the decimal point) to include the following:		*As of 4.3, numeric variables can now represent time of day in the fractional space (to the right of the decimal point) to include the following:

Laura: /* Handling Input */

2014-09-20T18:32:57Z

Handling Input

← Older revision		Revision as of 18:32, 20 September 2014
Line 48:		Line 48:
	* Any valid separator will be accepted where any separator is specified by the mask.		* Any valid separator will be accepted where any separator is specified by the mask.

	~~examples-~~		Examples:
	days("Tuesday 23 January, 2007",'day dd month, ccyy') -> 39104		days("Tuesday 23 January, 2007",'day dd month, ccyy') -> 39104
	days("January, 2007",'day dd month, ccyy') -> 39082 (day 1 assumed)		days("January, 2007",'day dd month, ccyy') -> 39082 (day 1 assumed)

Laura: /* Handling Input */

2014-09-20T18:32:39Z

Handling Input

← Older revision		Revision as of 18:32, 20 September 2014
Line 45:		Line 45:
	BR does not require that the entered value conform to the specified mask to avoid the entry of incorrect dates using unforeseen valid expressions. If a date format mask omits month, day, year and/or century, BR now assumes the first day of the current month for the respective omitted mask components. Values must conform to masks with the following exceptions:		BR does not require that the entered value conform to the specified mask to avoid the entry of incorrect dates using unforeseen valid expressions. If a date format mask omits month, day, year and/or century, BR now assumes the first day of the current month for the respective omitted mask components. Values must conform to masks with the following exceptions:

	* Any valid format for month or day is accepted on input where the mask requests the respective month or day.		* Any valid format for month or day is accepted on input where the mask requests the respective month or day.
	* Any valid separator will be accepted where any separator is specified by the mask.		* Any valid separator will be accepted where any separator is specified by the mask.

	examples-		examples-
Line 59:		Line 59:
	BR allows a null mask, but the omission of a mask does not denote a null mask. It denotes whatever the system default mask is currently set to, which could be the system default.		BR allows a null mask, but the omission of a mask does not denote a null mask. It denotes whatever the system default mask is currently set to, which could be the system default.

	*As of 4.3, numeric variables can now represent time of day in the fractional space (to the right of the decimal point) to include the following:		*As of 4.3, numeric variables can now represent time of day in the fractional space (to the right of the decimal point) to include the following:
	H#.## or H denotes hours (with fractions).		H#.## or H denotes hours (with fractions).
	M#.### or M#.# denotes minutes.		M#.### or M#.# denotes minutes.

Laura: /* Comments and Examples */

2014-09-20T18:32:16Z

Comments and Examples

← Older revision		Revision as of 18:32, 20 September 2014
Line 34:		Line 34:

	Line 98 returns zero because the format in line 97 only applies to that one function call. Since there is no asterisk in the date string, line 97 does not change the default date format, whereas line 95 does.		Line 98 returns zero because the format in line 97 only applies to that one function call. Since there is no asterisk in the date string, line 97 does not change the default date format, whereas line 95 does.

	~~As of 4.3, date numeric variables can now represent time of day in the fractional space (to the right of the decimal point). The DAYS and DATE masks have been extended as follows:~~

	*H#.## or H denotes hours [ with fractions ].
	*M#.### or M#.# denotes minutes.
	*S#.####, S or S# denotes seconds.

	===Parameters===		===Parameters===