PC SOFT

WINDEV的在线文档

  • Overview
文档页面当前正在翻译。对于此延迟我们深表歉意。
您可以自愿地帮助我们翻译您想要的文档段落,然后只需通过以下地址与我们联系:info@cn.windev.com
产品
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
平台
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
语言
JavaPHPAjax用户代码(MCU)外部语言
数据库
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

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 the 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 "DateTime" items, when the start date and the end date corresponds to values, the query editor offers 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.