UK railway Period Script
Sorry This may seem like a lazy post, but i have not done much scripting since forever and my attempts with the available BIRT functions are just not giving me anything useful.
I am running a report from Maximo, and i would like to return the network rail period based on the date from the report (i.e work order reported date). The aim is to group our report per railway period as opposed to month.
I am using BIRT Version: 3.7.1
I have attached my not so useful attempt and the the railway period start date calendar until 2035.
there are only 13 periods each year (Start of Period 14 on the attachment is effectively the last day of period 13)
from looking at it i can say,
Period 1 always starts on the 01/04
Period 13 always ends on the 31/03
there are usually four weeks in a period except the last and first one that can be a bit longer or shorter depending on where the 01/04 or 31/03 falls
There are generally no more than 4 Sundays in a period
Thanks in advanced