PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
  • ...
To display the records corresponding to a given period:
  1. Select "Query description" from the popup menu of the query. The description window of query is displayed.
  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.
Note: For the "DateTime" items, when the start and end dates correspond to values, the query editor proposes preset periods (current month, previous week, calendar year, ...). To use one of these preset periods, click the "Preset period" button and select the requested period.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment