diff options
Diffstat (limited to '')
| -rw-r--r-- | helpcontent2/source/text/sbasic/shared/03030105.xhp | 194 |
1 files changed, 194 insertions, 0 deletions
diff --git a/helpcontent2/source/text/sbasic/shared/03030105.xhp b/helpcontent2/source/text/sbasic/shared/03030105.xhp new file mode 100644 index 000000000..f2bd1dad4 --- /dev/null +++ b/helpcontent2/source/text/sbasic/shared/03030105.xhp @@ -0,0 +1,194 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + --> +<helpdocument version="1.0"> +<meta> + <topic id="textsbasicshared03030105xml" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">WeekDay Function</title> + <filename>/text/sbasic/shared/03030105.xhp</filename> + </topic> + <history> + <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> + </history> +</meta> +<body> +<section id="weekday"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153127"> + <bookmark_value>WeekDay function</bookmark_value> +</bookmark> + +<h1 id="hd_id3153127"><variable id="WeekDay_H1"><link href="text/sbasic/shared/03030105.xhp" name="WeekDay Function">WeekDay Function</link></variable></h1> +<paragraph role="paragraph" id="par_id3146795" xml-lang="en-US">This function returns the number corresponding to the weekday represented by a serial date number that is generated by the <literal>DateSerial</literal> or the <literal>DateValue</literal> functions.</paragraph> +</section> +<note id="par_id91620239579003">This help page describes the <literal>WeekDay</literal> function used in Basic scripts. If you are interested in the <literal>WeekDay</literal> function used in %PRODUCTNAME Calc, refer to <link href="text/scalc/01/func_weekday.xhp" name="WeekDay_Calc Function">this help page</link>.</note> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> +<bascode> + <paragraph role="bascode" id="par_id3149655" xml-lang="en-US">WeekDay (SerialDate, [FirstDayOfWeek])</paragraph> +</bascode> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> +<paragraph role="paragraph" id="par_id3151042" xml-lang="en-US"> +<emph>SerialDate:</emph> Integer expression that contains the serial date number that is used to calculate the day of the week.</paragraph> +<paragraph role="paragraph" id="par_id351619718411921"> +<emph>FirstDayOfWeek:</emph> Integer value indicating which weekday should be considered as the first day of the week. The default value is <emph>0</emph>, meaning that the system locale settings are used to determine the first day of the week.</paragraph> +<paragraph role="paragraph" id="par_id411619718769819">The parameter <emph>FirstDayOfWeek</emph> accepts values ranging from 0 to 7. The table below describes the meaning of each possible value:</paragraph> +<section id="WeekDay_constants"> +<table id="tab_id191619718816238"> + <tablerow> + <tablecell> + <paragraph id="par_id651619719561092" role="tablehead">Value</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id251619718816238" role="tablehead">VBA Constant</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id711619718816238" role="tablehead">Description</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id731619718847838" role="tablecontent" localize="false">0</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718847702" role="tablecontent" localize="false">vbUseSystemDayOfWeek</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id521619718818972" role="tablecontent">Use system locale settings</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719164117" role="tablecontent" localize="false">1</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718847885" role="tablecontent" localize="false">vbSunday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719174897" role="tablecontent">Sunday (default)</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719164241" role="tablecontent" localize="false">2</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718844633" role="tablecontent" localize="false">vbMonday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719173258" role="tablecontent">Monday</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719168871" role="tablecontent" localize="false">3</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718840122" role="tablecontent" localize="false">vbTuesday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719174633" role="tablecontent">Tuesday</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719162897" role="tablecontent" localize="false">4</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718843362" role="tablecontent" localize="false">vbWednesday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719173641" role="tablecontent">Wednesday</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719168022" role="tablecontent" localize="false">5</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718849336" role="tablecontent" localize="false">vbThursday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719170014" role="tablecontent">Thursday</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719164776" role="tablecontent" localize="false">6</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718849699" role="tablecontent" localize="false">vbFriday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719174271" role="tablecontent">Friday</paragraph> + </tablecell> + </tablerow> + <tablerow> + <tablecell> + <paragraph id="par_id821619719169044" role="tablecontent" localize="false">7</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id731619718849001" role="tablecontent" localize="false">vbSaturday</paragraph> + </tablecell> + <tablecell> + <paragraph id="par_id581619719176055" role="tablecontent">Saturday</paragraph> + </tablecell> + </tablerow> +</table> +</section> +<note id="par_id451619720094202">The VBA constants listed above are only available if VBA support has been enabled. For more information, read the <link href="text/sbasic/shared/03103350.xhp" name="VBASupport_Statement">VBASupport Statement</link> help page.</note> + +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> +<paragraph role="paragraph" id="par_id3154125" xml-lang="en-US">Integer</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> +<paragraph role="paragraph" id="par_id3159254" xml-lang="en-US">The following example uses the function <literal>Now()</literal> to determine the current weekday.</paragraph> +<bascode> +<paragraph role="bascode" id="par_id3145749" localize="false">Sub ExampleWeekDay</paragraph> +<paragraph role="bascode" id="par_id3147426" localize="false"> Dim sDay As String</paragraph> +<paragraph role="bascode" id="par_id3148576"> ' Return And display the day of the week</paragraph> +<paragraph role="bascode" id="par_id3155412" localize="false"> Select Case WeekDay( Now )</paragraph> +<paragraph role="bascode" id="par_id3151117"> Case 1: sDay="Sunday"</paragraph> +<paragraph role="bascode" id="par_id3153952"> Case 2: sDay="Monday"</paragraph> +<paragraph role="bascode" id="par_id3153157"> Case 3: sDay="Tuesday"</paragraph> +<paragraph role="bascode" id="par_id3154942"> Case 4: sDay="Wednesday"</paragraph> +<paragraph role="bascode" id="par_id3155416"> Case 5: sDay="Thursday"</paragraph> +<paragraph role="bascode" id="par_id3154015"> Case 6: sDay="Friday"</paragraph> +<paragraph role="bascode" id="par_id3153707"> Case 7: sDay="Saturday"</paragraph> +<paragraph role="bascode" id="par_id3155065" localize="false"> End Select</paragraph> +<paragraph role="bascode" id="par_id3148993"> MsgBox "" + sDay,64,"Today Is"</paragraph> +<paragraph role="bascode" id="par_id3149019" localize="false">End Sub</paragraph> +</bascode> +<paragraph role="paragraph" id="par_id891619721286262">The following example illustrates the use <emph>FirstDayOfWeek</emph> parameter, assuming that Tuesday is the first day of the week.</paragraph> +<bascode> + <paragraph role="bascode" localize="false" id="bas_id71619721723893">Dim someDay As Long</paragraph> + <paragraph role="bascode" id="bas_id791619721724107">' The date January 1st 2021 was a Friday</paragraph> + <paragraph role="bascode" localize="false" id="bas_id441619721724360">someDay = DateSerial(2021, 01, 01)</paragraph> + <paragraph role="bascode" id="bas_id991619721724568">' Prints "6" assuming Sunday is the first day of the week</paragraph> + <paragraph role="bascode" localize="false" id="bas_id291619721724784">MsgBox WeekDay(someDay)</paragraph> + <paragraph role="bascode" id="bas_id31619721725024">' Prints "4" assuming Tuesday is the first day of the week</paragraph> + <paragraph role="bascode" localize="false" id="bas_id301619721725289">MsgBox WeekDay(someDay, 3)</paragraph> +</bascode> + +<section id="relatedtopics"> + <embed href="text/sbasic/shared/03030101.xhp#DateSerial_H1"/> + <embed href="text/sbasic/shared/03030102.xhp#DateValue_H1"/> + <embed href="text/sbasic/shared/03030203.xhp#Now_H1"/> + <embed href="text/scalc/01/func_weekday.xhp#weekday"/> +</section> +</body> +</helpdocument> |