Virtual Table – Date

Hey,

Many times we have used Date as our Data Type in Tables and in Variables. Very often or even never we used Date as a Record Variable. This Post is all about using Date as a Record Data and we will see how powerful and helpful it is to use in our daily Programming.

This Virtual Table gives us a full fledge control on:

Period Type – Period Start – Period End – Period No – Period Name

Let’s see one example and make a Page from the standard Dynamics NAV wizard providing Date in the Table Name.

Capture

Currently in the above screenshot we have selected this Period Type as Date which explains –

Period Start – The Date which you have selected.

Period End – The Date which you have selected.

Period No – This shows the Days in Integer like  Monday – 1, Tuesday  – 2, Thursday – 3.

Period NameThis shows the name of respective Days.

Capture

Now in the above screenshot we have selected this Period Type as Week which explains –

Period Start – The Date which you have selected.

Period End – Date when week ends.

Period No – This shows starting week of the year and will continue till the year ends.

Period NameThis too shows the same information as above as week does not have a specific name.

Capture

Now in the above screenshot we have selected this Period Type as Month which explains –

Period Start – The Date which you have selected.

Period End – Date when month ends.

Period No – This shows the month in Integer like January – 1, February – 2, March – 3.

Period NameThis shows the name of respective Months.

Capture

Now in the above screenshot we have selected this Period Type as Quarter which explains –

Period Start – The Date which you have selected.

Period End – Date when quarter ends.

Period No – As we know quarters are of 3 month hence it’s now describing the quarter no..

Period NameThis too shows the same information as above.

Capture

Last but not the least now  we have selected this Period Type as Year which explains –

Period Start – The Date which you have selected.

Period End – Last day of the year..

Period No – Year.

Period NameThis too shows the same information as above.

Cheers.