ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / Operations on queries
  • Overview
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Query: Displaying the records corresponding to a given period
Overview
When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period.
For example:
  • the customers born between "01/01/1950" and "01/01/1960".
  • the orders placed last month.
  • the products sold yesterday.
  • etc.
To display the records corresponding to a given period:
  1. Select "Query description" in the context menu of the query. The query description window appears.
  2. In the middle section, select a "Date" item.
  3. In the right section, click the "Between two dates" button.
  4. Specify the start date and the end date, then validate.
Remark: For "DateTime" items, when the start and end dates are values, the query editor suggests preset periods (current month, previous week, calendar year, etc.). To use one of these preset periods, click the "Preset period" button and select the requested period.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help