How do I create fieldnames from a Date in a View

By tony.harris ·
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...
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums