Date Virtual Table

The Date virtual table gives you easy access to days, weeks, months, quarters, and years. The Date virtual table has 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.

The following illustration shows the Date virtual table. For each period type, there are many records in the Date table.

Dd355175.Local_-387659885_nav_adg_table_41(en-us,NAV.60).gif

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 forms or reports.

Date Virtual Table Example

The Date virtual table is most frequently used to provide a range of dates; the Receivables- Payables form is a typical example.

Dd355175.Local_-387659888_nav_adg_table_42(en-us,NAV.60).gif

See Also

Concepts

C/SIDE Virtual Tables