Hi to all;
I have a pivot table that contain "task-start-date" field I want to add a
costom field to my pivot table with this formula : =today()-"task-start-date"
but I recieve syntax error from calculated field option from pivot table
tools cosole.
I hope someone help me.tnx

You can't use the Today or Now functions in a pivot table formula. You
could enter a static date, such as DATE(2009,5,31) and subtract the
other date from that.

However, it would be best to enter your formula in the source data, and
calculate the date difference there. Then add that new field to the
pivot table.

Sedaghat Nejad wrote:
> Hi to all;
> I have a pivot table that contain "task-start-date" field I want to add a
> costom field to my pivot table with this formula : =today()-"task-start-date"
> but I recieve syntax error from calculated field option from pivot table
> tools cosole.
> I hope someone help me.tnx


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thanks a lot for your attention

"Debra Dalgleish" wrote:

> You can't use the Today or Now functions in a pivot table formula. You
> could enter a static date, such as DATE(2009,5,31) and subtract the
> other date from that.
>
> However, it would be best to enter your formula in the source data, and
> calculate the date difference there. Then add that new field to the
> pivot table.
>
> Sedaghat Nejad wrote:
> > Hi to all;
> > I have a pivot table that contain "task-start-date" field I want to add a
> > costom field to my pivot table with this formula : =today()-"task-start-date"
> > but I recieve syntax error from calculated field option from pivot table
> > tools cosole.
> > I hope someone help me.tnx
>
>
> --
> Debra Dalgleish
> Contextures
> www.contextures.com/tiptech.html
> Blog: http://blog.contextures.com
>
>