Bendinblues
Wed Oct 10 22:39:00 PDT 2007
Yes, I tried that. My real issue is that when |i export to Excel, I'm trying
to use a pivot table that lists projects by date. When i export the number
field from Excel, it returns a 1905 number for the year in the pivot table.
The cell is a date data type. So, I guess my solution is to use an excel cell
with a number data type for teh pivot table.
Thanks for your quick reply.
"Rod Gill" wrote:
> A date field expects a date, but Year([finish]) returns a number. Put the
> formula in a Number or Text field and it should work fine.
>
> --
>
> Rod Gill
> Project MVP
>
> Project VBA Book, for details visit:
>
http://www.projectvbabook.com
>
> NEW!! Web based VBA training course delivered by me. For details visit:
>
http://projectservertraining.com/learning/index.aspx
>
>
> ----------------------------------------------------------------------------------------------------
>
>
> "Bendinblues" <Bendinblues@discussions.microsoft.com> wrote in message
> news:A7687CEC-F2CF-46FA-BC6C-2A1D151060BA@microsoft.com...
> > geting a #error in custom field (date8). using formula year([finish]) to
> > calculate the year represented by the finish date for the task. Not
> > calculating. Help.
>
>
>