Date$ - Revision history

Gordon.dye at 15:31, 2 January 2022

2022-01-02T15:31:16Z

← Older revision		Revision as of 15:31, 2 January 2022
Line 48:		Line 48:
	00070 FORM CC 132		00070 FORM CC 132

	====~~Parameters~~====		====Extended Date Formats That May Include Time of Day====

			DATE$(days, "day month, ccyy") -> 23 January, 2007<br>
			DATE$(days, "d3 m3 dd, ccyy") -> Tue Jan 10, 2005<br>
			DAYS("January 17, 1945", "month dd, ccyy") -> 16435 (numeric days)

			DATE$( days, “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58 hours<br>
			DATE$( days, “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM<br>
			DATE$( days, “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM

			====Parameter Rules====

	When the Date$ function is used without parameters, it returns the current system date in the current default format, which is yy/mm/dd when Business Rules is started.		When the Date$ function is used without parameters, it returns the current system date in the current default format, which is yy/mm/dd when Business Rules is started.
Line 56:		Line 66:
	The optional "format$" parameter is a string expression which identifies the format of the value to be returned. When the first character of the string expression is an asterisk (*), it identifies the default format which should be used by the Date, Date$ and Days parameters until the computer exits Business Rules or until the format is changed again. Format changes affect the current computer only.		The optional "format$" parameter is a string expression which identifies the format of the value to be returned. When the first character of the string expression is an asterisk (*), it identifies the default format which should be used by the Date, Date$ and Days parameters until the computer exits Business Rules or until the format is changed again. Format changes affect the current computer only.

	The format$ parameter may include editing characters and any of the following date specifications: D (day), M (month), Y (year) or C (century)~~. The total number of editing characters and date specifications may not exceed 6~~. Consecutive repetitions (DDD, YY, etc.) of the date specifications count as just one specification, but consecutive repetitions of editing characters do not use this rule.		The format$ parameter may include editing characters and any of the following date specifications: D (day), M (month), Y (year) or C (century). Consecutive repetitions (DDD, YY, etc.) of the date specifications count as just one specification, but consecutive repetitions of other editing characters do not use this rule.

	The following rules apply to the format$ parameter for the Date$, Date and Days functions:		The following rules apply to the format$ parameter for the Date$, Date and Days functions:
Line 67:		Line 77:
	And as of 4.3:		And as of 4.3:

	<ol start="6">		<ol start="5">
	<li>M, to the right of H always denotes minutes, so H:M:S is sufficient.</li>		<li>M, to the right of H always denotes minutes, so H:M:S is sufficient.</li>
	<li>Either AM or PM, to the right of H denotes AM / PM output.</li>		<li>Either AM or PM, to the right of H denotes AM / PM output.</li>
Line 73:		Line 83:
	<li>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.</li>		<li>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.</li>
	</ol>		</ol>

	~~====Additional Supported Date Formats====~~

	~~DATE$(days, "day month, ccyy") -> 23 January, 2007<br>~~
	~~DATE$(days, "d3 m3 dd, ccyy") -> Tue Jan 10, 2005<br>~~
	~~DAYS("January 17, 1945", "month dd, ccyy") -> 16435 (numeric days)~~

	~~DATE$( days, “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58<br>~~
	~~DATE$( days, “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM<br>~~
	~~DATE$( days, “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM~~

	====Related Functions====		====Related Functions====

Gordon.dye: /* Comments and Examples */

2022-01-02T15:16:44Z

Comments and Examples

← Older revision		Revision as of 15:16, 2 January 2022
Line 38:		Line 38:
	As the above specification includes the asterisk, the default format for all future uses of the [[Date]], Date$ and [[Days]] functions is changed to mm-dd-ccyy, as specified.		As the above specification includes the asterisk, the default format for all future uses of the [[Date]], Date$ and [[Days]] functions is changed to mm-dd-ccyy, as specified.

	The following is a short program that will center "July 4, 1988" (or any other value set by the Date command) at the top of a report.		The following is a short program that will center "July 4, 1988" (or any other value set by the Date command) at the top of a report. Note that this example is for illustrative purposes only, because the extended formats below eliminate the need for this code snippet.

	00010 DIM MONTH$(12)*9		00010 DIM MONTH$(12)*9

Gordon.dye at 15:12, 2 January 2022

2022-01-02T15:12:25Z

← Older revision		Revision as of 15:12, 2 January 2022
Line 1:		Line 1:
	Date$(<days>[,*<format$>])		Date$
			Date$(<days>)
			Date$([*]<format$>)
			Date$(<days>,[*]<format$>)

	The '''Date$''' [[internal function]] returns the date as a formatted string which includes optional punctuation marks as separators between the month, day, and year. DATE$() works with day-of-century values along with an optional time fraction (use of fractions, 4.3+).		The '''Date$''' [[internal function]] returns the date as a formatted string which includes optional punctuation marks as separators between the month, day, and year. DATE$() works with day-of-century values along with an optional time fraction (use of fractions, 4.3+).

Gordon.dye at 15:07, 2 January 2022

2022-01-02T15:07:55Z

← Older revision		Revision as of 15:07, 2 January 2022
Line 1:		Line 1:
	Date$(<days>,[*<format$>])		Date$(<days>[,*<format$>])

	The '''Date$''' [[internal function]] returns the date as a formatted string which includes optional punctuation marks as separators between the month, day, and year. DATE$() works with day-of-century values along with an optional time fraction (use of fractions, 4.3+).		The '''Date$''' [[internal function]] returns the date as a formatted string which includes optional punctuation marks as separators between the month, day, and year. DATE$() works with day-of-century values along with an optional time fraction (use of fractions, 4.3+).

Gordon.dye: /* Parameters */

2022-01-02T14:59:53Z

Parameters

← Older revision		Revision as of 14:59, 2 January 2022
Line 60:		Line 60:
	# Consecutive repetitions of the D, M, Y or C specifications count as just one specification. Thus DDDD is one specification, and cc is one specification.		# Consecutive repetitions of the D, M, Y or C specifications count as just one specification. Thus DDDD is one specification, and cc is one specification.
	# All characters other than D, M, Y or C are considered editing characters, and are ignored for the numeric Date function.		# All characters other than D, M, Y or C are considered editing characters, and are ignored for the numeric Date function.
	# A maximum of six specifications are allowed. DD counts as one. Each punctuation mark counts as one. Date$("mm-dd-ccyy") uses the maximum. Date$("mm -dd -yy") would result in error code 0411 (date format string too long) because there are three date specifications and four editing characters for a total of seven specifications.
	# If the string parameter begins with an asterisk (*), then the default format is changed. The default format affects results of the Date, Date$ and Days functions. This change applies only to the current workstation and stays in effect until you leave Business Rules.		# If the string parameter begins with an asterisk (*), then the default format is changed. The default format affects results of the Date, Date$ and Days functions. This change applies only to the current workstation and stays in effect until you leave Business Rules.

Gordon.dye: /* Additional Supported Date Formats */

2018-09-29T13:35:30Z

Additional Supported Date Formats

← Older revision		Revision as of 13:35, 29 September 2018
Line 74:		Line 74:
	====Additional Supported Date Formats====		====Additional Supported Date Formats====

	DATE$(days,"day month, ccyy") -> 23 January, 2007<br>		DATE$(days, "day month, ccyy") -> 23 January, 2007<br>
	DATE$(days,"d3 m3 dd, ccyy") -> Tue Jan 10, 2005<br>		DATE$(days, "d3 m3 dd, ccyy") -> Tue Jan 10, 2005<br>
	DAYS("January 17, 1945", "month dd, ccyy")		DAYS("January 17, 1945", "month dd, ccyy") -> 16435 (numeric days)

	DATE$( “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58<br>		DATE$( days, “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58<br>
	DATE$( “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM<br>		DATE$( days, “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM<br>
	DATE$( “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM		DATE$( days, “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM

	====Related Functions====		====Related Functions====

Gordon.dye: /* Additional Supported Date Formats */

2018-09-29T13:29:44Z

Additional Supported Date Formats

← Older revision		Revision as of 13:29, 29 September 2018
Line 78:		Line 78:
	DAYS("January 17, 1945", "month dd, ccyy")		DAYS("January 17, 1945", "month dd, ccyy")

	DATE$( “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58		DATE$( “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58<br>
	DATE$( “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM		DATE$( “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM<br>
	DATE$( “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM		DATE$( “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM

Laura at 18:34, 20 September 2014

2014-09-20T18:34:11Z

← Older revision		Revision as of 18:34, 20 September 2014
Line 1:		Line 1:
	Date$(<days>,[*<format$>])		Date$(<days>,[*<format$>])

	The '''Date$''' [[internal function]] returns the date as a formatted string which includes optional punctuation marks as separators between the month, day, and year.		The '''Date$''' [[internal function]] returns the date as a formatted string which includes optional punctuation marks as separators between the month, day, and year. DATE$() works with day-of-century values along with an optional time fraction (use of fractions, 4.3+).

	====Comments and Examples====		====Comments and Examples====
Line 86:		Line 86:
	See also [[Date]] and [[Days]] for other date processing functions. To set the system date, use the [[Date (Command)]]. For other features especially useful in markets outside the United States, see the [[Option (Config)\|INVP]] parameter of the Option statement and the [[Pic$]] function		See also [[Date]] and [[Days]] for other date processing functions. To set the system date, use the [[Date (Command)]]. For other features especially useful in markets outside the United States, see the [[Option (Config)\|INVP]] parameter of the Option statement and the [[Pic$]] function

			===Saving Dates===
			When storing date/time combinations in a data file, you should allow for all of the significant digits that your date mask supports on each side of the decimal point. A “BH 4.4” form supports nine significant digits, which is suitable for day of century plus a four digit fraction. To exceed that you can use either PD 6.6, PD 7.6, PD 8.6 or D 8 (double floating point) to store these values. Note that BR rounds internally at six digits by default.
	<noinclude>		<noinclude>
	[[Category:Internal Functions]]		[[Category:Internal Functions]]
	</noinclude>		</noinclude>

Laura: /* Additional Supported Date Formats */

2014-09-20T18:29:27Z

Additional Supported Date Formats

← Older revision		Revision as of 18:29, 20 September 2014
Line 77:		Line 77:
	DATE$(days,"d3 m3 dd, ccyy") -> Tue Jan 10, 2005<br>		DATE$(days,"d3 m3 dd, ccyy") -> Tue Jan 10, 2005<br>
	DAYS("January 17, 1945", "month dd, ccyy")		DAYS("January 17, 1945", "month dd, ccyy")

			DATE$( “Month dd, ccyy at H#.##”) -> September 12, 2011 at 14.58
			DATE$( “mm/dd/yy at H:M AM”) -> 09/15/11 at 2:35 PM
			DATE$( “mon dd cy at H#:M# PM”) -> Sep 15 2011 at 02:35 PM

	====Related Functions====		====Related Functions====

Laura: /* Parameters */

2014-09-20T18:29:07Z

Parameters

← Older revision		Revision as of 18:29, 20 September 2014
Line 64:		Line 64:

	And as of 4.3:		And as of 4.3:

	<ol start="6">		<ol start="6">
	#M, to the right of H always denotes minutes, so H:M:S is sufficient.		<li>M, to the right of H always denotes minutes, so H:M:S is sufficient.</li>
	#Either AM or PM, to the right of H denotes AM / PM output.		<li>Either AM or PM, to the right of H denotes AM / PM output.</li>
	#The absence of AM and PM denote military hours (0 – 23).		<li>The absence of AM and PM denote military hours (0 – 23).</li>
	#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.		<li>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.</li>
			</ol>

	====Additional Supported Date Formats====		====Additional Supported Date Formats====