Month value of the finish date

[Brian Lukanic]

In Project Center, I want the ability to group by "finish month" A project
with a finish date of "11/23/2009" would appear as "2009-11" or "November
2009," for instance.

I am assuming I need to create a project-level field that uses a formula
against Finish date. Can anybody help me with the syntax of that?

 

[Jonathan Sofer [MVP]]

You can use a project custom TEXT field and the formula would be:

=Year([Project Finish]) & "-" & Month([Project Finish])

Jonathan Sofer

 

[Ben Howard]

Neat.... Thanks Jonathan
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

You can use a project custom TEXT field and the formula would be:

=Year([Project Finish]) & "-" & Month([Project Finish])

Jonathan Sofer

In Project Center, I want the ability to group by "finish month" A project
with a finish date of "11/23/2009" would appear as "2009-11" or "November
2009," for instance.

I am assuming I need to create a project-level field that uses a formula
against Finish date. Can anybody help me with the syntax of that?