<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tg/onlinemanual/000033" xml:lang="de">
   <Header>
      <Title>Calculated date and time formula definitions</Title>
   </Header>
   <GeneralSection>
      <Paragraph>The calculated date and
		time formulas can be linked to business processes and activities in the <Link href="/baanerp/tg/glossary/glossary#000040" role="glossary">business process model</Link> of
		the <Link href="/baanerp/tg/glossary/glossary#000078" role="glossary">project model</Link>.</Paragraph>
      <Paragraph>The calculated date and
		time formulas are interpreted by <Link href="/baanerp/tg/glossary/glossary#000045" role="glossary">Workflow Management System</Link> to determine the <Link href="/baanerp/tg/glossary/glossary#000048" role="glossary">target date and time</Link> of the <Link href="/baanerp/tg/glossary/glossary#000067" role="glossary">business</Link> process and its <Link href="/baanerp/tg/glossary/glossary#000023" role="glossary">activities</Link> at the moment
		that the business process is initiated.</Paragraph>
      <Paragraph>The target date of the
		business process is also the target date of the activities within the business
		process unless a target date is defined for the individual activity. The target
		date of the business process overrules the target date of the activity if the
		target date of the activity is later than that of the business process.</Paragraph>
      <List>
         <ListIntro>To define the target date of a business process:</ListIntro>
         <ListItem>Start the <Link href="/baanerp/tg/brg/tgbrg4500m000" role="session">Project Models (tgbrg4500m000)</Link> session.</ListItem>
         <ListItem>Select a <Link href="/baanerp/tg/glossary/glossary#000078" role="glossary">project model</Link>.</ListItem>
         <ListItem>On the Specific menu click Business Process Model.</ListItem>
         <ListItem>Double-click a listed business process.</ListItem>
      </List>
      <List>
         <ListIntro>To define the target date for an activity:</ListIntro>
         <ListItem>Select a business process.</ListItem>
         <ListItem>Start the <Link href="/baanerp/tg/glossary/glossary#000307" role="glossary">Enterprise Modeler Editor</Link>.</ListItem>
         <ListItem>Double-click the activity.</ListItem>
      </List>
   </GeneralSection>
   <GeneralSection ID="X">
      <Paragraph>The date part of the
		formula can contain the arguments; x, day, month, year, and week.</Paragraph>
      <Paragraph>X represents the date or
		time that the formula is interpreted by the <Link href="/baanerp/tg/glossary/glossary#000047" role="glossary">Workflow Engine</Link> for the
		initiating business process.</Paragraph>
      <Paragraph>The day argument can
		represent the day of the month (valid values 1 through 31), or the day of the
		week (valid values 1 through 7, which represent, for example, Sunday through
		Saturday).</Paragraph>
      <Paragraph>The month, year, and
		week arguments represent themselves.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for formula group box must contain a test value for each argument present
		  in the formula. From top to bottom, each field is only used in the test if all
		  fields above it contain a value, regardless of whether they are included in the
		  formula or not.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Example data:</SectionTitle>
      <Paragraph>In the examples given, x
		is Monday, 3 June 1996 (which is week 23). The first day of week 23 is Sunday.</Paragraph>
      <List>
         <ListItem> 
            <Link href="#A" role="internal">BEGIN_OF_MONTH(x)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#B" role="internal">END_OF_MONTH(x)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#C" role="internal">DAY_OF_MONTH(x, day)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#D" role="internal">MONTH_OF_YEAR(x, month)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#E" role="internal">DAY_OF_MONTH_OF_YEAR(x, day, month)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#F" role="internal">DAY_OF_WEEK(x, day)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#G" role="internal">FUTURE_DAY_OF_WEEK(x, day)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#H" role="internal">WEEK_OF_YEAR(x, week)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#I" role="internal">FUTURE_WEEK_OF_YEAR(x, week)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#J" role="internal">DAY_OF_WEEK_OF_YEAR(x, day, week)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#K" role="internal">FUTURE_MONTH(x)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#L" role="internal">FUTURE_YEAR(x)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#M" role="internal">LOWER(x)</Link>
         </ListItem>
         <ListItem> 
            <Link href="#N" role="internal">UPPER(x)</Link>
         </ListItem>
      </List>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_MONTH(x)</SectionTitle>
      <Paragraph>The first day of the
		month in which day x falls. This formula is short for definition DAY_OF
		MONTH(x, 1)</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_MONTH(x)</SectionTitle>
      <Paragraph>The last day of the
		month in which day x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		month in which day x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>MONTH_OF_YEAR(x, month)</SectionTitle>
      <Paragraph>The first day of the
		indicated month in the year in which x falls, which is short for the definition
		DAY_OF_MONTH_OF_YEAR(x, 1, month).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH_OF_YEAR(x, day, month)</SectionTitle>
      <Paragraph>The day and month
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_MONTH(x)</SectionTitle>
      <Paragraph>The first day of the
		month in which day x falls. This formula is short for definition DAY_OF
		MONTH(x, 1)</Paragraph>
      <Paragraph>Result of the example
		data: 1 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_MONTH(x)</SectionTitle>
      <Paragraph>The last day of the
		month in which day x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		month in which day x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>MONTH_OF_YEAR(x, month)</SectionTitle>
      <Paragraph>The first day of the
		indicated month in the year in which x falls, which is short for the definition
		DAY_OF_MONTH_OF_YEAR(x, 1, month).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH_OF_YEAR(x, day, month)</SectionTitle>
      <Paragraph>The day and month
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_MONTH(x)</SectionTitle>
      <Paragraph>The last day of the
		month in which day x falls.</Paragraph>
      <Paragraph>Result of the example
		data: 30 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		month in which day x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>MONTH_OF_YEAR(x, month)</SectionTitle>
      <Paragraph>The first day of the
		indicated month in the year in which x falls, which is short for the definition
		DAY_OF_MONTH_OF_YEAR(x, 1, month).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH_OF_YEAR(x, day, month)</SectionTitle>
      <Paragraph>The day and month
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		month in which day x falls.</Paragraph>
      <Paragraph>Valid values for the day
		argument are 1 through 31.</Paragraph>
      <Paragraph>Result of the example
		data: If the day is 13, it refers to 13 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>MONTH_OF_YEAR(x, month)</SectionTitle>
      <Paragraph>The first day of the
		indicated month in the year in which x falls, which is short for the definition
		DAY_OF_MONTH_OF_YEAR(x, 1, month).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH_OF_YEAR(x, day, month)</SectionTitle>
      <Paragraph>The day and month
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>MONTH_OF_YEAR(x, month)</SectionTitle>
      <Paragraph>The first day of the
		indicated month in the year in which x falls, which is short for the definition
		DAY_OF_MONTH_OF_YEAR(x, 1, month).</Paragraph>
      <Paragraph>Result of the example
		data: If the month is 4, it refers to 1 April 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH_OF_YEAR(x, day, month)</SectionTitle>
      <Paragraph>The day and month
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_MONTH_OF_YEAR(x, day, month)</SectionTitle>
      <Paragraph>The day and month
		indicated in the year in which x falls.</Paragraph>
      <Paragraph>Valid values for the day
		argument are 1 through 31.</Paragraph>
      <Paragraph>Result of the example
		data: If day is 17 and the month is 10, they refer to 17 October 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>The indicated day in the
		week in which x falls.</Paragraph>
      <Paragraph>Valid values for the day
		argument are 1 through 7.</Paragraph>
      <Paragraph>Result of the example
		data: If the day is 1, it refers to 2 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_DAY_OF_WEEK(x, day)</SectionTitle>
      <Paragraph>If the indicated day
		precedes x, then it is the day indicated in the week after the week in which x
		falls, else it is the day indicated in the week in which x falls.</Paragraph>
      <Paragraph>Valid values for the day
		argument are 1 through 7.</Paragraph>
      <Paragraph>Result of the example
		data: If the day is 1, it refers to 9 June 1996. Day 1 precedes x, which is day
		2 of the week. So, this day refers to the first day of the next week.</Paragraph>
      <Paragraph>Result of the example
		data: If the day is 2, it refers to 3 June 1996, because 3 June is exactly day
		2 of the week.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>The first working day of
		the indicated week in the year in which x falls, which is short for the
		definition DAY_OF_WEEK_OF_YEAR(x, 1, week).</Paragraph>
      <Paragraph>Result of the example
		data: If the week is 22, it refers to 27 May 1996.</Paragraph>
      <Paragraph>Result of the example
		data: If the week is 24, it refers to 10 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_WEEK_OF_YEAR(x, week)</SectionTitle>
      <Paragraph>If the indicated week
		precedes or equals that of x, it is the first working day of the indicated week
		in the year after the year in which x falls; Otherwise, this day refers to the
		first working day of the indicated week in the year in which x falls.</Paragraph>
      <Paragraph>Result of the example
		data: If the week is 22, it refers to 26 May 1997. X falls after week 22, So,
		it refers to the first day of week 22 in the following year.</Paragraph>
      <Paragraph>Result of the example
		data: If the week is 24, it refers to 10 June 1996. X falls before week 24, So,
		it refers to the first day of week 24 in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>DAY_OF_WEEK_OF_YEAR(x, day, week)</SectionTitle>
      <Paragraph>The day and week
		indicated in the year in which x falls.</Paragraph>
      <Paragraph>Valid values for the day
		argument are 1 through 7.</Paragraph>
      <Paragraph>Result of the example
		data: If the day is 2 and the week is 23, they refer to 28 October 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_MONTH(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the month is one month later than the
		current date. Otherwise, it is exactly x.</Paragraph>
      <Paragraph>This formula only has
		meaning if x is determined by other formulas, otherwise the result is always x
		itself!</Paragraph>
      <Paragraph>Examples of nested
		FUTURE_MONTH definitions: FUTURE_MONTH(BEGIN_OF_MONTH(x))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 1 June 1996, which is the date the
		outer formula uses. The 1 June precedes the current date of 4 June, so the
		outcome of the complete formula is 1 July 1996.</Paragraph>
      <Paragraph>FUTURE_MONTH(MONTH_OF_YEAR(x, 4))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 1 April 1996, which is the date the
		outer formula uses. The 1 April precedes the current date of 4 June, so the
		outcome of the complete formula is 1 July 1996. This day is the same day of the
		month but one month later then the current date.</Paragraph>
      <Paragraph>FUTURE_MONTH(MONTH_OF_YEAR(x, 8))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 1 August 1996, which is the date the
		outer formula uses. The 1 August succeeds the current date of 4 June, so the
		outcome of the complete formula is 1 August 1996.</Paragraph>
      <Paragraph>FUTURE_MONTH(END_OF_MONTH(x))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 30 June 1996, which is the date the
		outer formula uses. The 30 June succeeds the current date of 4 June, so the
		outcome of the complete formula is 30 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>FUTURE_YEAR(x)</SectionTitle>
      <Paragraph>If x precedes the
		current date, the result is x, but the year is one year later than the current
		date. Otherwise, it is exactly x.</Paragraph>
      <Paragraph>This formula only has
		meaning if x is determined by other formulas, otherwise the result is always x
		itself!</Paragraph>
      <Paragraph>Examples of nested
		FUTURE YEAR definitions are: FUTURE_YEAR(MONTH_OF_YEAR(x, 4))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 1 April 1996, which is the date the
		outer formula uses. The 1 April precedes the current date of 4 June, so the
		outcome of the complete formula is 1 April 1997.</Paragraph>
      <Paragraph>FUTURE_YEAR(MONTH_OF_YEAR(x, 9))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 1 September 1996, which is the date
		the outer formula uses. The 1 September succeeds the current date of 4 June so
		the outcome of the complete formula is 1 September 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>LOWER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the last working day before x; otherwise it refers to x itself.</Paragraph>
      <Paragraph>Result of the example
		data: X is a working day, so, it refers to x itself 3 June 1996.</Paragraph>
      <Paragraph/>
      <Paragraph>Example of nested LOWER
		definition: LOWER(END_OF_MONTH(x))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 30 June 1996, which is the date the
		outer formula uses. The 30 June is a Sunday, so go back to the last working
		day, which is 28 June 1996.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>UPPER(x)</SectionTitle>
      <Paragraph>If x is a holiday, it
		refers to the first working day after x. Otherwise, it refers to x itself.</Paragraph>
      <Paragraph>Result of the example
		data: X is a working day, so, it refers to x itself 3 June 1996.</Paragraph>
      <Paragraph/>
      <Paragraph>Example of nested UPPER
		definition: UPPER(MONTH_OF_YEAR(x, 9))</Paragraph>
      <Paragraph>Result of the example
		data: The outcome of the inner formula is 1 September 1996, which is the date
		the outer formula uses. The 1 September is a Sunday, so go forward to the first
		working day, which is 2 September 1996. As a result a formula exists for the
		first working day, which in this case is September.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x)</SectionTitle>
      <Paragraph>The start of the working
		day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>BEGIN_OF_DAY(x) + 1</SectionTitle>
      <Paragraph>One hour after the start
		of the day.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>END_OF_DAY(x) - 2:30</SectionTitle>
      <Paragraph>Two and an half hours
		before the end of the day.</Paragraph>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>When x is not a
		  working day, the time will be set to 0.</Paragraph>
      </Note>
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection ID="Z">
      <Note>
         <SectionTitle>Note</SectionTitle>
         <Paragraph>The fields in the Test
		  data for the formula group box must contain a test value for each argument
		  present in the formula. From top to bottom, each field is only used in the test
		  if all fields above it contain a value, whether or not they are included in the
		  formula.</Paragraph>
      </Note>
   </GeneralSection>
   <GeneralSection ID="AA">
      <ExampleSection>
         <SectionTitle>Example</SectionTitle>
         <Paragraph/>
         <Paragraph>FUTURE_MONTH(BEGIN_OF_MONTH(x))</Paragraph>
         <Paragraph>To create this formula
		  select BEGIN_OF_MONTH and then FUTURE_MONTH</Paragraph>
         <Paragraph>or</Paragraph>
         <Paragraph>DAY_OF_MONTH_OF_YEAR(BEGIN_OF_MONTH(x), day, month)</Paragraph>
         <Paragraph>To create this formula
		  select BEGIN_OF_MONTH(x) and then DAY_OF_MONTH_OF_YEAR(x, day, month)</Paragraph>
      </ExampleSection>
   </GeneralSection>
</ManualTopic>