Function idvAgeBandPeriods

Description

This function is given the period of a posting. It produces an age band value that splits conventionally according less than 1, less than 2, less than 3 etc and returns the result as a string, chosen to sort correctly. The routine will work for four bands (three cutoff points) or seven (six cutoff points).

 

Parameters

@pPostPeriod

The period of the posting.

@pBands

The number of bands (4 or 7)

Returns

The Age band as a string