Create a custom field with Project creation date

%3CLINGO-SUB%20id%3D%22lingo-sub-2042781%22%20slang%3D%22en-US%22%3ECreate%20a%20custom%20field%20with%20Project%20creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042781%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22question-body%20post-body%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Project%20Server%2C%20I'm%20trying%20to%20build%20a%20view%20and%20in%20this%20view%2C%20I'd%20like%20to%20group%20my%20projects%20by%20date%20of%20creation%20(MM%2FYY)%2C%20so%20to%20that%2C%20I%20write%20a%20foncion%20but%20I'm%20not%20able%20to%20use%20the%20%5BCreated%5D%20with%20my%20custom%20field%2C%20I%20performed%20some%20tests%20with%20Year(%5BCreated%5D)%20but%20it%20returns%20empty%20value%20all%20the%20time%2C%3C%2FP%3E%3CP%3Eso%20in%20my%20custom%20field%20formula%20I%20just%20added%3A%20%5BCreated%5D%20and%20the%20result%20is%20the%20same%2C%20it%20returns%20no%20value%3C%2FP%3E%3CP%3EBut%20where%20this%20thing%20is%20pretty%20weird%20is%20when%20Iadd%20the%20column%20created%20in%20my%20view%2C%20I%20have%20some%20data%20inside%2C%20I%20did%20some%20tests%20with%20other%20dates%20and%20everything%20is%20working%2C%20I'm%20just%20meeting%20this%20issue%20with%20the%20Creation%20data%20of%20Project%3C%2FP%3E%3CP%3EAny%20idea%20of%20what%20I'm%20doing%20wrong%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2042781%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EProject%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2043397%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20custom%20field%20with%20Project%20creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043397%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922030%22%20target%3D%22_blank%22%3E%40Toxicboumboum%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EYou%20should%20be%20able%20to%20use%20just%20%5BCreated%5D%20in%20the%20formula%20but%20once%20the%20custom%20field%20is%20created%20you%20will%20need%20to%20open%20and%20publish%20each%20project%20before%20you%20will%20see%20a%20value%20in%20the%20new%20custom%20field.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2043641%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20custom%20field%20with%20Project%20creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2043641%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922030%22%20target%3D%22_blank%22%3E%40Toxicboumboum%3C%2FA%3E%26nbsp%3B-%20I%20just%20ran%20a%20quick%20test.%26nbsp%3B%20I%20created%20a%20new%20Project%20Center%20view%20and%20added%20the%20Created%20column%20to%20the%20view.%26nbsp%3B%20When%20I%20navigated%20to%20the%20Project%20Center%20page%20and%20applied%20the%20custom%20view%2C%20the%20Created%20column%20correctly%20shows%20the%20creation%20date%20of%20each%20project.%26nbsp%3B%20So%2C%20I%20do%20not%20know%20why%20you%20are%20attempting%20to%20create%20a%20custom%20field%20when%20the%20default%20Created%20field%20contains%20the%20data%20you%20seek.%26nbsp%3B%20Hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2048143%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20custom%20field%20with%20Project%20creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2048143%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20answer%2C%20but%20this%20is%20the%20tricky%20point%3C%2FP%3E%3CP%3EIt%20doesn't%20work%2C%20I%20know%20that%20I%20have%20to%20republish%20my%20Project%20to%20take%20this%20value%3CBR%20%2F%3EI%20continue%20to%20investigate%20and%20I%20found%20something%20weird%2C%3C%2FP%3E%3CP%3ESo%20as%20mentionned%2C%20In%20my%20project%20center%20view%2C%20for%20the%20%5BCreated%5D%2C%20I%20have%20a%20date%20but%20If%20I%20open%20a%20Project%20in%20MSProject%2C%20I%20add%20the%20column%20created%20and%20there%2C%20the%20colum%20indicates%20N%2FA%3C%2FP%3E%3CP%3EIt%20looks%20like%20that%20the%20custom%20field%20which%20has%20to%20use%20%5BCreated%5D%20is%20not%20reading%20data%20from%20the%20same%20table%20than%20in%20my%20Project%20center%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2048147%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20custom%20field%20with%20Project%20creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2048147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F112666%22%20target%3D%22_blank%22%3E%40Dale%20Howard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20dale%2C%20thank%20you%20for%20your%20reply%3C%2FP%3E%3CP%3EIn%20fact%2C%20I'd%20like%20to%20group%20my%20project%20by%20Month%20creation%20%2C%3C%2FP%3E%3CP%3ESo%20I%20tried%20to%20build%20a%20custom%20field%20like%3A%3C%2FP%3E%3CP%3EMonth(%5BCreated%5D%2FYear(%5BCreated%5D)%20but%20each%20time%2C%20this%20field%20returns%20%2F%2C%20so%20for%20my%20test%2C%20I'd%20just%20try%20to%20add%20%5BCreated%5D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2050822%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20custom%20field%20with%20Project%20creation%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2050822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F922030%22%20target%3D%22_blank%22%3E%40Toxicboumboum%3C%2FA%3E%26nbsp%3B--%20You%20will%20need%20to%20create%20an%20enterprise%20custom%20Project%20field%20that%20is%20the%20Text%20type.%26nbsp%3B%20In%20the%20field%2C%20enter%20the%20following%20formula%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMonth(%5BCreated%5D)%20%26amp%3B%20%22%2F%22%20%26amp%3B%20Year(%5BCreated%5D)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20you%20create%20and%20save%20the%20formula%20in%20Project%20Web%20App%2C%20you%20will%20need%20to%20open%20each%20project%20in%20Microsoft%20Project%20Professional%2C%20press%20the%20F9%20function%20key%20to%20recalculate%20the%20project%20(and%20the%20formula%20value%20for%20that%20project)%2C%20then%20you%20will%20need%20to%20save%20and%20publish%20the%20project.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20cannot%20merely%20create%20the%20formula%20and%20expect%20it%20to%20work%20for%20all%20existing%20projects.%26nbsp%3B%20When%20you%20create%20new%20enterprise%20custom%20fields%20AFTER%20projects%20have%20already%20been%20created%2C%20you%20have%20to%20open%20each%20project%2C%20recalculate%20the%20project%2C%20then%20save%20and%20publish%20it.%26nbsp%3B%20Any%20project%20created%20AFTER%20you%20created%20the%20enterprise%20custom%20field%20will%20automatically%20recalculate%20the%20custom%20field%20value.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20think%20you%20have%20been%20skipping%20some%20very%20important%20steps.%26nbsp%3B%20Hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello Everyone,

 

In Project Server, I'm trying to build a view and in this view, I'd like to group my projects by date of creation (MM/YY), so to that, I write a foncion but I'm not able to use the [Created] with my custom field, I performed some tests with Year([Created]) but it returns empty value all the time,

so in my custom field formula I just added: [Created] and the result is the same, it returns no value

But where this thing is pretty weird is when Iadd the column created in my view, I have some data inside, I did some tests with other dates and everything is working, I'm just meeting this issue with the Creation data of Project

Any idea of what I'm doing wrong?

Thank you for your help

8 Replies

Hello @Toxicboumboum ,

You should be able to use just [Created] in the formula but once the custom field is created you will need to open and publish each project before you will see a value in the new custom field.

Paul

@Toxicboumboum - I just ran a quick test.  I created a new Project Center view and added the Created column to the view.  When I navigated to the Project Center page and applied the custom view, the Created column correctly shows the creation date of each project.  So, I do not know why you are attempting to create a custom field when the default Created field contains the data you seek.  Hope this helps.

@Paul Mather 

Thank you for your answer, but this is the tricky point

It doesn't work, I know that I have to republish my Project to take this value
I continue to investigate and I found something weird,

So as mentionned, In my project center view, for the [Created], I have a date but If I open a Project in MSProject, I add the column created and there, the colum indicates N/A

It looks like that the custom field which has to use [Created] is not reading data from the same table than in my Project center

@Dale Howard 

Hello dale, thank you for your reply

In fact, I'd like to group my project by Month creation ,

So I tried to build a custom field like:

Month([Created]/Year([Created]) but each time, this field returns /, so for my test, I'd just try to add [Created]

@Toxicboumboum -- You will need to create an enterprise custom Project field that is the Text type.  In the field, enter the following formula:

 

Month([Created]) & "/" & Year([Created])

 

After you create and save the formula in Project Web App, you will need to open each project in Microsoft Project Professional, press the F9 function key to recalculate the project (and the formula value for that project), then you will need to save and publish the project.

 

You cannot merely create the formula and expect it to work for all existing projects.  When you create new enterprise custom fields AFTER projects have already been created, you have to open each project, recalculate the project, then save and publish it.  Any project created AFTER you created the enterprise custom field will automatically recalculate the custom field value.

 

I think you have been skipping some very important steps.  Hope this helps.

Hello @Dale Howard 

Once again, thank you for your help

Just to show you the weird result I get, I created two custom fields, the first one is Start Month with the following formula Month([Start]) &"/"&Year([Start]) and another field called Created Month with this formula Month([Created]) &"/"&Year([Created]) 

So I republish a project and here you can see the result attached

 

As you can see Start Month is working perfectly but I have an issue with Created date

 

 

@Toxicboumboum -- After creating the formulas, did you open each enterprise project, press the F9 key to recalculate it, then save and publish it?  The formulas will not work if you don't do those steps.  Let us know and we will try to help you.

@Dale Howard 

Normally I didnt open MS Project, I open the Project in Project Server then I edit it and republish

I performed a test in MS Project, so I open a Project, I press F9, I save and then I republish and now I have an empty field for my formula, before I had  a / but not my custom field is totally empty

(If I redo my previous operation in Project Center, the / will appear again)

In Ms Project for [Created], I have NA and in Project Center I have a date, do you think that could have an impact on my final result?

Once again, I just have this issue for [Created[ for example, if I select [Start],  everything works perfectly