I have five fields in a select statement;
Machine, JobNo, Customer, JobStartDate, JobFinishDate.
I wish to add more columns to the result showing the days (CurrentDate-7) to (CurrentDate + 60) as columns with the actual date as the caption of the column, formatted as ‘dd/mm/yyyy’ (Australian); in order to show an indicator if the job is active on that day…
e.g.
Mc, Job, Customer, Start, Finish, 23/03/2010, 24/03/2010, 25/03/2010…
M4322, HN01110, Delta Mining, 24/03/2010, 29/10/2010,_,*,*,…
Any and all help would be gratefully received.
