Date virtual table
The Date virtual table (ID 2000000007) gives you easy access to days, weeks, months, quarters, and years. The Date virtual table contains the following fields.
Field | Description |
---|---|
Period Type | Days, weeks, months, quarters, or years. |
Period Start | The date of the first day in the period. |
Period End | The date of the last day in the period. |
Period No. | The number of the period. |
Period Name | The name of the period. |
For each period type, there are many records in the Date table.
The Period End
field returns the closing date at the end of the period. For more information, see System.ClosingDate(Date) Method.
You can apply filters to the Period Type
, Period Start
, and Period End
fields to easily get a subset or range of days, weeks, months, quarters, or years to use in your pages or reports.
The date virtual table is most frequently used to provide a range of dates; the Receivables-Payables page in Business Central is a typical example.
You must create a list type page to access the Date virtual table. For more information, see Page object.
See also
意見反應
https://aka.ms/ContentUserFeedback。
即將登場:在 2024 年,我們將逐步淘汰 GitHub 問題作為內容的意見反應機制,並將它取代為新的意見反應系統。 如需詳細資訊,請參閱:提交並檢視相關的意見反應