E67 - Employee Pension Dates (Payroll Report Generator variable)

Syntax

E67{M/W/E/O/T/J/N, N/T, CCYYMMDD, C/A}

Description

Outputs one of the dates regarding the employee's pension depending on the parameter supplied.

Parameters

M/W/E/O/T/J/N

A text parameter that can be omitted (it defaults to "M").

M

The date the employee (worker) joined a qualifying pension scheme.

W

The date that the employee (worker) has deferred automatic enrolment.

E

The date that the eligible jobholder has deferred automatic enrolment.

O

The date an opt-out notice was given to the employer.

T

The date the employee (worker) voluntarily terminated active membership of a qualifying scheme.

J

The date the employee (worker) is to start active membership of a scheme following their notice to join.

N

The date the employer received a valid pension notice from the employee (worker).

N/T

A text parameter that can be omitted (it defaults to "N").

N

Numeric result. This is the number of days since the first of January 1980. This is most commonly used for sorting purposes.

T

Text result. This is the date formatted for display, e.g. '01/01/2004'. You can optionally use the next parameter to control the exact format.

CCYYMMDD

A text parameter that can be omitted (it defaults to "DD/MM/CCYY").

When the previous parameter is 'T', this parameter can be used to control the exact format. The following four values can be combined in any order, with separating characters if required.

DD

Day (01 to 31).

MM

Month (01 to 12).

CC

Century (19 or 20).

YY

Year (00 to 99).

DD/MM/CCYY Same as the default. MM/DD/CCYY Output in USA format. CCYYMMDD Use for sorting into date order (would have the same effect as using the numeric result). CCYYMM Use for grouping by month.

C/A

A text parameter that can be omitted (it defaults to "C").

C

Current: applicable to the most recent (re-)enrolment only.

A

All: any date stored even if for an earlier (re-)enrolment.

Returns

A text or numeric (depending on the parameters) value whose typical size is 10 characters.

Feedback

Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'

Keywords AND Misspellings

date, day, month, year