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.

FieldDescription
Period TypeDays, weeks, months, quarters, or years.
Period StartThe date of the first day in the period.
Period EndThe date of the last day in the period.
Period No.The number of the period.
Period NameThe 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. Learn more in 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. Learn more in Page object.

Virtual tables
Integer virtual table