Difference between revisions of "M04 - Qualifying Week/Match Notified (Payroll Report Generator variable)"
(Updated from revision control) |
(Updated from revision control) |
||
Line 7: | Line 7: | ||
SAP/OSPP(adoption)/ASPP(adoption) - the date the adopter was notified of being matched with a child. The Matching Week is the Sunday on or before this date. | SAP/OSPP(adoption)/ASPP(adoption) - the date the adopter was notified of being matched with a child. The Matching Week is the Sunday on or before this date. | ||
+ | |||
+ | SPBP - the Relavent Week - the Sunday the week before the child's death. | ||
Latest revision as of 06:50, 17 March 2020
Syntax
M04{N/T, CCYYMMDD}
Description
SMP/OSPP(birth)/ASPP(birth) - the Qualifying Week - the Sunday 15 weeks before the baby is due.
SAP/OSPP(adoption)/ASPP(adoption) - the date the adopter was notified of being matched with a child. The Matching Week is the Sunday on or before this date.
SPBP - the Relavent Week - the Sunday the week before the child's death.
Parameters
- 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).
|
Returns
A text or numeric (depending on the parameters) value whose typical size is 10 characters.