diff options
author | RĂ¼diger Timm <rt@openoffice.org> | 2004-11-26 13:55:36 +0000 |
---|---|---|
committer | RĂ¼diger Timm <rt@openoffice.org> | 2004-11-26 13:55:36 +0000 |
commit | d019e26d52e1a8850a9ab6fed71e28c659ca75f5 (patch) | |
tree | 231729751d4789bdbcb14686b45faff8125c817d | |
parent | 8bf1da41a8e8ef3a27b3ca63511c6801f26c93c2 (diff) |
INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED
2004/09/16 11:45:21 fpe 1.1.2.1: Regular Update
-rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030102.xhp | 54 | ||||
-rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030103.xhp | 53 | ||||
-rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030104.xhp | 54 | ||||
-rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03030105.xhp | 85 |
4 files changed, 128 insertions, 118 deletions
diff --git a/helpcontent2/source/text/sbasic/shared/03030102.xhp b/helpcontent2/source/text/sbasic/shared/03030102.xhp index 18221cc211..0d1a3cb6c7 100755 --- a/helpcontent2/source/text/sbasic/shared/03030102.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030102.xhp @@ -52,39 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030102xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">DateValue Function [Runtime]</title> +<title id="tit" xml-lang="en-US">DateValue Function [Runtime]</title> <filename>/text/sbasic/shared/03030102.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T11:22:07">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="datevalue"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3156344"><bookmark_value>DateValue;function</bookmark_value></bookmark><paragraph id="hd_id3156344" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030102.xhp" name="DateValue Function [Runtime]">DateValue Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3150542" l10n="U" xml-lang="en-US" oldref="2">Returns a number from a date string. The date string is a complete date in a single numeric value. You can also use this serial number to determine the difference between two dates.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3148799" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3154910" l10n="U" xml-lang="en-US" oldref="4">DateValue [(date)]</paragraph> - <paragraph role="heading" level="2" id="hd_id3150870" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3153194" l10n="U" xml-lang="en-US" oldref="6">Long</paragraph> - <paragraph role="heading" level="2" id="hd_id3153969" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3153770" xml-lang="en-US" oldref="8"><emph>Date:</emph> String expression that contains the date that you want to calculate. The date can be specified in almost any format.</paragraph> - <paragraph role="paragraph" id="par_id3153189" l10n="U" xml-lang="en-US" oldref="22">You can use this function to convert a date that occurs between December 1, 1582 and December 31, 9999 into a single integer value. You can then use this value to calculate the difference between two dates. If the date argument lies outside the acceptable range, $[officename] Basic returns an error message.</paragraph> - <paragraph role="paragraph" id="par_id3146974" l10n="U" xml-lang="en-US" oldref="23">In contrast to the DateSerial function that passes years, months, and days as separate numeric values, the DateValue function passes the date using the format "month.[,]day.[,]year".</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#languageformat"/> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3153142" l10n="U" xml-lang="en-US" oldref="24">Example:</paragraph> - <paragraph role="paragraph" id="par_id3155412" l10n="U" xml-lang="en-US" oldref="25">Sub ExampleDateValue</paragraph> - <paragraph role="paragraph" id="par_id3153363" l10n="U" xml-lang="en-US" oldref="26">msgbox DateValue("12/02/1997")</paragraph> - <paragraph role="paragraph" id="par_id3149262" l10n="U" xml-lang="en-US" oldref="27">end sub</paragraph> - - </body> +<section id="datevalue"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3156344"><bookmark_value>DateValue function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3156344" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030102.xhp" name="DateValue Function [Runtime]">DateValue Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3150542" xml-lang="en-US" l10n="U" oldref="2">Returns a number from a date string. The date string is a complete date in a single numeric value. You can also use this serial number to determine the difference between two dates.</paragraph> +</section> +<paragraph role="heading" id="hd_id3148799" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3154910" xml-lang="en-US" l10n="U" oldref="4">DateValue [(date)]</paragraph> +<paragraph role="heading" id="hd_id3150870" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3153194" xml-lang="en-US" l10n="U" oldref="6">Long</paragraph> +<paragraph role="heading" id="hd_id3153969" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Date:</emph> String expression that contains the date that you want to calculate. The date can be specified in almost any format.</paragraph> +<paragraph role="paragraph" id="par_id3153189" xml-lang="en-US" l10n="U" oldref="22">You can use this function to convert a date that occurs between December 1, 1582 and December 31, 9999 into a single integer value. You can then use this value to calculate the difference between two dates. If the date argument lies outside the acceptable range, $[officename] Basic returns an error message.</paragraph> +<paragraph role="paragraph" id="par_id3146974" xml-lang="en-US" l10n="U" oldref="23">In contrast to the DateSerial function that passes years, months, and days as separate numeric values, the DateValue function passes the date using the format "month.[,]day.[,]year".</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#languageformat"/> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3153142" xml-lang="en-US" level="2" l10n="U" oldref="24">Example:</paragraph> +<paragraph role="paragraph" id="par_id3155412" xml-lang="en-US" l10n="U" oldref="25">Sub ExampleDateValue</paragraph> +<paragraph role="paragraph" id="par_id3153363" xml-lang="en-US" l10n="U" oldref="26">msgbox DateValue("12/02/1997")</paragraph> +<paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="U" oldref="27">end sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030103.xhp b/helpcontent2/source/text/sbasic/shared/03030103.xhp index 0676360453..0188b6e4d4 100755 --- a/helpcontent2/source/text/sbasic/shared/03030103.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030103.xhp @@ -52,38 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030103xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Day Function [Runtime]</title> +<title id="tit" xml-lang="en-US">Day Function [Runtime]</title> <filename>/text/sbasic/shared/03030103.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T11:22:33">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="day"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153345"><bookmark_value>Day;function</bookmark_value></bookmark><paragraph id="hd_id3153345" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030103.xhp" name="Day Function [Runtime]">Day Function [Runtime]</link></paragraph> - <paragraph xml-lang="en-US" oldref="2" role="paragraph" id="par_id3147560" l10n="U">Returns a value that represents the day of the month based on a serial date number generated by <emph>DateSerial</emph> or <emph>DateValue</emph>.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3149456" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3150358" l10n="U" xml-lang="en-US" oldref="4">Day (Number)</paragraph> - <paragraph role="heading" level="2" id="hd_id3148798" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3125865" l10n="U" xml-lang="en-US" oldref="6">Integer</paragraph> - <paragraph role="heading" level="2" id="hd_id3150448" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3156423" xml-lang="en-US" oldref="8"><emph>Number:</emph> A numeric expression that contains a serial date number from which you can determine the day of the month.</paragraph> - <paragraph xml-lang="en-US" oldref="9" role="paragraph" id="par_id3145786" l10n="U">This function is basically the opposite of the DateSerial function, returning the day of the month from a serial date number generated by the <emph>DateSerial</emph> or the <emph>DateValue</emph> function. For example, the expression</paragraph> - <paragraph role="paragraph" id="par_id3145364" l10n="U" xml-lang="en-US" oldref="10">Print Day (DateSerial(1994, 12, 20))</paragraph> - <paragraph role="paragraph" id="par_id3153190" l10n="U" xml-lang="en-US" oldref="11">returns the value 20.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3149481" l10n="U" xml-lang="en-US" oldref="12">Example:</paragraph> - <paragraph role="paragraph" id="par_id3155413" l10n="U" xml-lang="en-US" oldref="13">sub ExampleDay</paragraph> - <paragraph role="paragraph" id="par_id3149260" l10n="U" xml-lang="en-US" oldref="14">Print "Day " & Day(DateSerial(1994, 12, 20)) & " of the month"</paragraph> - <paragraph role="paragraph" id="par_id3148645" l10n="U" xml-lang="en-US" oldref="15">end sub</paragraph> - </body> +<section id="day"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153345"><bookmark_value>Day function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030103.xhp" name="Day Function [Runtime]">Day Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3147560" xml-lang="en-US" l10n="U" oldref="2">Returns a value that represents the day of the month based on a serial date number generated by <emph>DateSerial</emph> or <emph>DateValue</emph>.</paragraph> +</section> +<paragraph role="heading" id="hd_id3149456" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3150358" xml-lang="en-US" l10n="U" oldref="4">Day (Number)</paragraph> +<paragraph role="heading" id="hd_id3148798" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3125865" xml-lang="en-US" l10n="U" oldref="6">Integer</paragraph> +<paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Number:</emph> A numeric expression that contains a serial date number from which you can determine the day of the month.</paragraph> +<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US" l10n="U" oldref="9">This function is basically the opposite of the DateSerial function, returning the day of the month from a serial date number generated by the <emph>DateSerial</emph> or the <emph>DateValue</emph> function. For example, the expression</paragraph> +<paragraph role="paragraph" id="par_id3145364" xml-lang="en-US" l10n="U" oldref="10">Print Day (DateSerial(1994, 12, 20))</paragraph> +<paragraph role="paragraph" id="par_id3153190" xml-lang="en-US" l10n="U" oldref="11">returns the value 20.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3149481" xml-lang="en-US" level="2" l10n="U" oldref="12">Example:</paragraph> +<paragraph role="paragraph" id="par_id3155413" xml-lang="en-US" l10n="U" oldref="13">sub ExampleDay</paragraph> +<paragraph role="paragraph" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="14">Print "Day " & Day(DateSerial(1994, 12, 20)) & " of the month"</paragraph> +<paragraph role="paragraph" id="par_id3148645" xml-lang="en-US" l10n="U" oldref="15">end sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030104.xhp b/helpcontent2/source/text/sbasic/shared/03030104.xhp index 42fe7c452d..31a6a554d0 100755 --- a/helpcontent2/source/text/sbasic/shared/03030104.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030104.xhp @@ -52,39 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030104xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Month Function [Runtime]</title> +<title id="tit" xml-lang="en-US">Month Function [Runtime]</title> <filename>/text/sbasic/shared/03030104.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T13:41:09">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="month"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153127"><bookmark_value>Month;function</bookmark_value></bookmark><paragraph id="hd_id3153127" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030104.xhp" name="Month Function [Runtime]">Month Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3148550" l10n="U" xml-lang="en-US" oldref="2">Returns the month of a year from a serial date that is generated by the DateSerial or the DateValue function.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3145068" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3150398" l10n="U" xml-lang="en-US" oldref="4">Month (Number)</paragraph> - <paragraph role="heading" level="2" id="hd_id3154366" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3154125" l10n="U" xml-lang="en-US" oldref="6">Integer</paragraph> - <paragraph role="heading" level="2" id="hd_id3150768" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3156423" xml-lang="en-US" oldref="8"><emph>Number:</emph> Numeric expression that contains the serial date number that is used to determine the month of the year.</paragraph> - <paragraph xml-lang="en-US" oldref="9" l10n="U" role="paragraph" id="par_id3153770">This function is the opposite of the <emph>DateSerial </emph>function. It returns the month in the year that corresponds to the serial date that is generated by <emph>DateSerial</emph> or <emph>DateValue</emph>. For example, the expression</paragraph> - <paragraph role="paragraph" id="par_id3147426" l10n="U" xml-lang="en-US" oldref="10">Print Month(DateSerial(1994, 12, 20))</paragraph> - <paragraph role="paragraph" id="par_id3145366" l10n="U" xml-lang="en-US" oldref="11">returns the value 12.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3146923" l10n="U" xml-lang="en-US" oldref="12">Example:</paragraph> - <paragraph role="paragraph" id="par_id3156442" l10n="U" xml-lang="en-US" oldref="13">Sub ExampleMonth</paragraph> - <paragraph role="paragraph" id="par_id3149664" l10n="U" xml-lang="en-US" oldref="14">MsgBox "" & Month(Now) ,64,"The current month"</paragraph> - <paragraph role="paragraph" id="par_id3150012" l10n="U" xml-lang="en-US" oldref="15">End sub</paragraph> - - </body> +<section id="month"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153127"><bookmark_value>Month function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3153127" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030104.xhp" name="Month Function [Runtime]">Month Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US" l10n="U" oldref="2">Returns the month of a year from a serial date that is generated by the DateSerial or the DateValue function.</paragraph> +</section> +<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="U" oldref="4">Month (Number)</paragraph> +<paragraph role="heading" id="hd_id3154366" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3154125" xml-lang="en-US" l10n="U" oldref="6">Integer</paragraph> +<paragraph role="heading" id="hd_id3150768" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Number:</emph> Numeric expression that contains the serial date number that is used to determine the month of the year.</paragraph> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="U" oldref="9">This function is the opposite of the <emph>DateSerial </emph>function. It returns the month in the year that corresponds to the serial date that is generated by <emph>DateSerial</emph> or <emph>DateValue</emph>. For example, the expression</paragraph> +<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="10">Print Month(DateSerial(1994, 12, 20))</paragraph> +<paragraph role="paragraph" id="par_id3145366" xml-lang="en-US" l10n="U" oldref="11">returns the value 12.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3146923" xml-lang="en-US" level="2" l10n="U" oldref="12">Example:</paragraph> +<paragraph role="paragraph" id="par_id3156442" xml-lang="en-US" l10n="U" oldref="13">Sub ExampleMonth</paragraph> +<paragraph role="paragraph" id="par_id3149664" xml-lang="en-US" l10n="U" oldref="14">MsgBox "" & Month(Now) ,64,"The current month"</paragraph> +<paragraph role="paragraph" id="par_id3150012" xml-lang="en-US" l10n="U" oldref="15">End sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03030105.xhp b/helpcontent2/source/text/sbasic/shared/03030105.xhp index ae189f8ffa..ff6b25addf 100755 --- a/helpcontent2/source/text/sbasic/shared/03030105.xhp +++ b/helpcontent2/source/text/sbasic/shared/03030105.xhp @@ -52,54 +52,57 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03030105xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">WeekDay Function [Runtime]</title> +<title id="tit" xml-lang="en-US">WeekDay Function [Runtime]</title> <filename>/text/sbasic/shared/03030105.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T14:55:15">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="weekday"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153127"><bookmark_value>WeekDay;function</bookmark_value></bookmark><paragraph id="hd_id3153127" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03030105.xhp" name="WeekDay Function [Runtime]">WeekDay Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3146795" l10n="U" xml-lang="en-US" oldref="2">Returns the number corresponding to the weekday represented by a serial date number that is generated by the DateSerial or the DateValue function.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3145068" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3149655" l10n="U" xml-lang="en-US" oldref="4">WeekDay (Number)</paragraph> - <paragraph role="heading" level="2" id="hd_id3148799" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3154125" l10n="U" xml-lang="en-US" oldref="6">Integer</paragraph> - <paragraph role="heading" level="2" id="hd_id3150768" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3151042" xml-lang="en-US" oldref="8"><emph>Number:</emph> Integer expression that contains the serial date number that is used to calculate the day of the week (1-7).</paragraph> - <paragraph role="paragraph" id="par_id3159254" l10n="U" xml-lang="en-US" oldref="9">The following example determines the day of the week using the WeekDay function when you enter a date.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3148616" l10n="U" xml-lang="en-US" oldref="10">Example:</paragraph> - <paragraph role="paragraph" id="par_id3145749" l10n="U" xml-lang="en-US" oldref="11">Sub ExampleWeekDay</paragraph> - <paragraph role="paragraph" id="par_id3147426" l10n="U" xml-lang="en-US" oldref="12">Dim sDay As String</paragraph> - <paragraph role="paragraph" id="par_id3148576" l10n="U" xml-lang="en-US" oldref="13">REM Return and display the day of the week</paragraph> - <paragraph role="paragraph" id="par_id3155412" l10n="U" xml-lang="en-US" oldref="14">Select Case WeekDay( Now )</paragraph> - <paragraph role="paragraph" id="par_id3155306" l10n="U" xml-lang="en-US" oldref="15">case 1</paragraph> - <paragraph role="paragraph" id="par_id3151117" l10n="U" xml-lang="en-US" oldref="16">sDay="Sunday"</paragraph> - <paragraph role="paragraph" id="par_id3152460" l10n="U" xml-lang="en-US" oldref="17">case 2</paragraph> - <paragraph role="paragraph" id="par_id3153952" l10n="U" xml-lang="en-US" oldref="18">sDay="Monday"</paragraph> - <paragraph role="paragraph" id="par_id3149666" l10n="U" xml-lang="en-US" oldref="19">case 3</paragraph> - <paragraph role="paragraph" id="par_id3153157" l10n="U" xml-lang="en-US" oldref="20">sDay="Tuesday"</paragraph> - <paragraph role="paragraph" id="par_id3154730" l10n="U" xml-lang="en-US" oldref="21">case 4</paragraph> - <paragraph role="paragraph" id="par_id3154942" l10n="U" xml-lang="en-US" oldref="22">sDay="Wednesday"</paragraph> - <paragraph role="paragraph" id="par_id3145799" l10n="U" xml-lang="en-US" oldref="23">case 5</paragraph> - <paragraph role="paragraph" id="par_id3155416" l10n="U" xml-lang="en-US" oldref="24">sDay="Thursday"</paragraph> - <paragraph role="paragraph" id="par_id3150716" l10n="U" xml-lang="en-US" oldref="25">case 6</paragraph> - <paragraph role="paragraph" id="par_id3154015" l10n="U" xml-lang="en-US" oldref="26">sDay="Friday"</paragraph> - <paragraph role="paragraph" id="par_id3146971" l10n="U" xml-lang="en-US" oldref="27">case 7</paragraph> - <paragraph role="paragraph" id="par_id3153707" l10n="U" xml-lang="en-US" oldref="28">sDay="Saturday"</paragraph> - <paragraph role="paragraph" id="par_id3155065" l10n="U" xml-lang="en-US" oldref="29">End Select</paragraph> - <paragraph role="paragraph" id="par_id3148993" l10n="U" xml-lang="en-US" oldref="30">msgbox "" + sDay,64,"Today is"</paragraph> - <paragraph role="paragraph" id="par_id3149019" l10n="U" xml-lang="en-US" oldref="31">End Sub</paragraph> - </body> +<section id="weekday"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153127"><bookmark_value>WeekDay function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3153127" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03030105.xhp" name="WeekDay Function [Runtime]">WeekDay Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3146795" xml-lang="en-US" l10n="U" oldref="2">Returns the number corresponding to the weekday represented by a serial date number that is generated by the DateSerial or the DateValue function.</paragraph> +</section> +<paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US" l10n="U" oldref="4">WeekDay (Number)</paragraph> +<paragraph role="heading" id="hd_id3148799" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3154125" xml-lang="en-US" l10n="U" oldref="6">Integer</paragraph> +<paragraph role="heading" id="hd_id3150768" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3151042" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Number:</emph> Integer expression that contains the serial date number that is used to calculate the day of the week (1-7).</paragraph> +<paragraph role="paragraph" id="par_id3159254" xml-lang="en-US" l10n="U" oldref="9">The following example determines the day of the week using the WeekDay function when you enter a date.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3148616" xml-lang="en-US" level="2" l10n="U" oldref="10">Example:</paragraph> +<paragraph role="paragraph" id="par_id3145749" xml-lang="en-US" l10n="U" oldref="11">Sub ExampleWeekDay</paragraph> +<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="12">Dim sDay As String</paragraph> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="13">REM Return and display the day of the week</paragraph> +<paragraph role="paragraph" id="par_id3155412" xml-lang="en-US" l10n="U" oldref="14">Select Case WeekDay( Now )</paragraph> +<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US" l10n="U" oldref="15">case 1</paragraph> +<paragraph role="paragraph" id="par_id3151117" xml-lang="en-US" l10n="U" oldref="16">sDay="Sunday"</paragraph> +<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="U" oldref="17">case 2</paragraph> +<paragraph role="paragraph" id="par_id3153952" xml-lang="en-US" l10n="U" oldref="18">sDay="Monday"</paragraph> +<paragraph role="paragraph" id="par_id3149666" xml-lang="en-US" l10n="U" oldref="19">case 3</paragraph> +<paragraph role="paragraph" id="par_id3153157" xml-lang="en-US" l10n="U" oldref="20">sDay="Tuesday"</paragraph> +<paragraph role="paragraph" id="par_id3154730" xml-lang="en-US" l10n="U" oldref="21">case 4</paragraph> +<paragraph role="paragraph" id="par_id3154942" xml-lang="en-US" l10n="U" oldref="22">sDay="Wednesday"</paragraph> +<paragraph role="paragraph" id="par_id3145799" xml-lang="en-US" l10n="U" oldref="23">case 5</paragraph> +<paragraph role="paragraph" id="par_id3155416" xml-lang="en-US" l10n="U" oldref="24">sDay="Thursday"</paragraph> +<paragraph role="paragraph" id="par_id3150716" xml-lang="en-US" l10n="U" oldref="25">case 6</paragraph> +<paragraph role="paragraph" id="par_id3154015" xml-lang="en-US" l10n="U" oldref="26">sDay="Friday"</paragraph> +<paragraph role="paragraph" id="par_id3146971" xml-lang="en-US" l10n="U" oldref="27">case 7</paragraph> +<paragraph role="paragraph" id="par_id3153707" xml-lang="en-US" l10n="U" oldref="28">sDay="Saturday"</paragraph> +<paragraph role="paragraph" id="par_id3155065" xml-lang="en-US" l10n="U" oldref="29">End Select</paragraph> +<paragraph role="paragraph" id="par_id3148993" xml-lang="en-US" l10n="U" oldref="30">msgbox "" + sDay,64,"Today is"</paragraph> +<paragraph role="paragraph" id="par_id3149019" xml-lang="en-US" l10n="U" oldref="31">End Sub</paragraph> +</body> </helpdocument> |