<html> <head> <title>Constants' Group DataPilotFieldGroupBy</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="stylesheet" type="text/css" href="../../../../idl.css"> </head> <body> <div id="adc-idlref"> <a name="_top_"> </a><table class="navimain" border="0" cellpadding="3"> <tr> <td class="navimain"><a href="../module-ix.html" class="navimain">Overview</a></td> <td class="navimain"><a href="module-ix.html" class="navimain">Module</a></td> <td class="navimainnone">Use</td> <td class="navimainnone">Devguide</td> <td class="navimain"><a href="../../../../index-files/index-1.html" class="navimain">Index</a></td> </tr> </table> <table class="navisub" border="0" cellpadding="0"> <tr> <td class="navisub"><a href="#Constants" class="navisub">Constants</a></td> <td class="navisub"><a href="#ConstantDetails" class="navisub">Constants' Details</a></td> </tr> </table> <hr> <table border="0" width="100%" cellpadding="5" cellspacing="3" class="title-table" style="margin-bottom:6pt;"> <tr> <td><p class="namechain"><a href="../../../../module-ix.html" class="namechain">::</a> <a href="../../../module-ix.html" class="namechain">com</a> :: <a href="../../module-ix.html" class="namechain">sun</a> :: <a href="../module-ix.html" class="namechain">star</a> :: <a href="module-ix.html" class="namechain">sheet</a> :: </p> </td> </tr> <tr> <td class="title">constants group DataPilotFieldGroupBy</td> </tr> <tr> <td><dl> <dt><b>Description</b></dt> <dd>These constants select different types for grouping members of a DataPilot field by date or time. </dd> <dt><b>See also</b></dt> <dd><a href="DataPilotFieldGroupInfo.html">DataPilotFieldGroupInfo</a></dd> </dl> </td> </tr> </table> <hr> <a name="Constants"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle" colspan="2">Constants</td> </tr> <tr> <td class="imsum_left"><a href="#SECONDS">SECONDS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their current value for seconds. </td> </tr> <tr> <td class="imsum_left"><a href="#MINUTES">MINUTES</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their current value for minutes. </td> </tr> <tr> <td class="imsum_left"><a href="#HOURS">HOURS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their current value for hours. </td> </tr> <tr> <td class="imsum_left"><a href="#DAYS">DAYS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their calendar day, or by ranges of days. </td> </tr> <tr> <td class="imsum_left"><a href="#MONTHS">MONTHS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their month. </td> </tr> <tr> <td class="imsum_left"><a href="#QUARTERS">QUARTERS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their quarter. </td> </tr> <tr> <td class="imsum_left"><a href="#YEARS">YEARS</a></td> <td class="imsum_right">Groups all members of a DataPilot field containing a date/time value by their year. </td> </tr> </table> <a name="ConstantDetails"/><table border="1" width="100%" cellpadding="5" cellspacing="0" class="subtitle"> <tr> <td class="subtitle">Constants' Details</td> </tr> <tr> <td class="imdetail"><a name="SECONDS" class="membertitle">SECONDS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>SECONDS</b> = 1;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their current value for seconds. </dd> <dd><p>Example: The group <em>:02</em> will contain all members that contain a time with a seconds value of 2, regardless of the date, hours and minutes of the member, e.g. <em>2002-Jan-03 00:00:02</em> or <em>1999-May-02 12:45:02</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MINUTES" class="membertitle">MINUTES</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MINUTES</b> = 2;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their current value for minutes. </dd> <dd><p>Example: The group <em>:02</em> will contain all members that contain a time with a minutes value of 2, regardless of the date, hours and seconds of the member, e.g. <em>2002-Jan-03 00:02:00</em> or <em>1999-May-02 12:02:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="HOURS" class="membertitle">HOURS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>HOURS</b> = 4;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their current value for hours. </dd> <dd><p>Example: The group <em>02</em> will contain all members that contain a time with a hour value of 2, regardless of the date, minutes and seconds of the member, e.g. <em>2002-Jan-03 02:00:00</em> or <em>1999-May-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="DAYS" class="membertitle">DAYS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>DAYS</b> = 8;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their calendar day, or by ranges of days. </dd> <dd><p>Examples: <ul> <li>Calendar day grouping: The group <em>Jan 03</em> will contain all members that contain the January 3rd, regardless of the year or time of the member, e.g. <em>2002-Jan-03 00:00:00</em> or <em>1999-Jan-03 02:12:45</em>.</li> <li>Day range grouping: The group <em>2002-Jan-03 - 2002-Jan-09</em> will contain all members with a date/time in the range from 2002-Jan-03 00:00:00 through 2002-Jan-09 23:59:59.</li> </ul></p> <p>See descriptions for <a href="XDataPilotFieldGrouping.html">XDataPilotFieldGrouping</a>::<a href="XDataPilotFieldGrouping.html#createDateGroup">createDateGroup</a> for more details about day grouping.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="MONTHS" class="membertitle">MONTHS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>MONTHS</b> = 16;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their month. </dd> <dd><p>Example: The group <em>Jan</em> will contain all members with a date in the month January, regardless of the year, day, or time of the member, e.g. <em>2002-Jan-03 00:00:00</em> or <em>1999-Jan-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="QUARTERS" class="membertitle">QUARTERS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>QUARTERS</b> = 32;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their quarter. </dd> <dd><p>Example: The group <em>Q1</em> will contain all members with a date in the first quarter of a year (i.e. the months January, February, and march), regardless of the year, day, or time of the member, e.g. <em>2002-Jan-03 00:00:00</em> or <em>1999-Mar-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> <tr> <td class="imdetail"><a name="YEARS" class="membertitle">YEARS</a><table border="0" width="96%" cellpadding="5" cellspacing="0" class="table-in-data" bgcolor="#ffffff" align="center"> <tr> <td>const long <b>YEARS</b> = 64;<hr> <dl> <dt><b>Description</b></dt> <dd>Groups all members of a DataPilot field containing a date/time value by their year. </dd> <dd><p>Example: The group <em>1999</em> will contain all members with a date in the year 1999, regardless of the month, day, or time of the member, e.g. <em>1999-Jan-03 00:00:00</em> or <em>1999-May-02 02:12:45</em>.</p> </dd> </dl> </td> </tr> </table> </td> </tr> </table> <a href="#_top_">Top of Page</a><hr size="3"><p class="copyright" align="center">Copyright © 2000, 2012 LibreOffice contributors and/or their affiliates. All rights reserved.</p><p class="copyright" align="center">LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.</p><p class="copyright" align="center">The Document Foundation acknowledges all community members, please find more info <a href="http://www.libreoffice.org/about-us/credits/" target="_blank">at our website</a>.<p> </p><p class="copyright" align="center"><a href="http://www.libreoffice.org/privacy" target="_blank">Privacy Policy</a> | <a href="http://www.libreoffice.org/imprint" target="_blank">Impressum (Legal Info)</a> | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (<a href="http://www.libreoffice.org/download/license/" target="_blank">LGPLv3</a>). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our <a href="http://wiki.documentfoundation.org/TradeMark_Policy" target="_blank">trademark policy</a>.</p> </div> <!-- id="adc-idlref" --> </body> </html>
