I am having a slight problem, the solution works perfectly for records in the past but will only display a working pattern up to the current date.

For example if I specify a start date of 2012-08-01 and an end date of 2012-12-31 it will give me the working pattern from 2012-08-01 up to today's date.

Is there any way to extend this to show dates in the future using the employees last entered working pattern?