Based on From Date and To date.. we have to calculate the column.

[harika321]

Hi,

I m facing with one issue, Please help on this.

we have January, Feb,mar..Upto December. these are the columns.

our requirement is..we have Resource column and Jan, feb, ...upto December columns.

Now we have to calculate total hours worked per resource. here we have to create one query calculation column,and we have to calculate based on From Date and To Date.

here we need one date prompt.

Please help on this. Its urgent issue.

Advance Thanks for you
... I am waiting for your reply...

[DustPanMan]

Harika,

WHy not create a range prompt on time.  Then create a new Query Item called "Month" that is set as extract(month, [Date]).  You can then add that Query Item to the columns area.  Make sure that your range prompt is set to the same [Date] that you use in your Query Item.

Best,

Dustin