Skip to Content
0
Former Member
Jun 15, 2009 at 05:37 AM

Dynamic months names

149 Views

Hi all,

i have the Final Output Table with the fields Workstart Date and WorkEnd date.

lets us say the work start date is 01-01-2009 and

workend date is 31-12-2009.

so, in my final output table i want to generate 12 dynamic columns, each column referring to each month.

like 01-01-2009 is the first column

01-02-2009 is the second column

01--3-2009 is the third column etc.

the work start date and workend date is are also varying depending upon requirement.

if work start date is 01-01-2009 and

workend date is 31-12-2010. then in this case i have to generate 24 dynamic columns.

How to do this.

Thanks

Kamala