How do I create fieldnames from a Date in a View - TechRepublic
Question
March 29, 2010 at 08:41 PM
tony.harris

How do I create fieldnames from a Date in a View

by tony.harris . Updated 16 years, 3 months ago

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.

This discussion is locked

All Comments