Understanding Date Variables on Vacancy and Posting reports

B0104: Vacancy Report

On the Vacancy Report, the `As of Day' variable represents both the Vacancy Start Date and Vacancy End Date in the report. In the above screenshot, the `As of Day' entered is 08/01/2007. This means the report will return data for a date range that has:

Vacancy Start Date <= `As of Day' >= Vacancy End Date

See details below,

(Vacancy Start Date less than or equal to 08/01/2007 AND,

Vacancy End Date greater than or equal to 08/01/2007)

B0168: Posting History

On the Posting History report, the `As of Day' variable represents the Posting Open Date in the report. In the above screenshot, the `As of Day' entered is 08/01/2007. This means the report will return data for:

Posting Open Dates <= `As of Day'

See detail below,

Posting Open Dates that are less than or equal to 08/01/2007

B0169: Vacancy History (Last 12 Month)

On the Vacancy History report, the `As of Day' variable represents both the Vacancy Start Date and Vacancy End Date in the report. In the above screenshot, the `As of Day' entered is 08/01/2007. This means the report will return data for a date range that has:

Vacancy Start Date between ((`As of Day' - 365) to `As of Day')

Vacancy End Date >= `As of Day

See details below,

(Vacancy Start Date = 08/01/2006 to 08/01/2007 AND,

Vacancy End Date greater than or equal to 08/01/2007)