Forum Discussion
Solved
Inconsistent Values from PWA Custom Field Formula
Hello community. Greetings from first time poster. I created the following formula (“FY Project Completion”) to assign a Financial Year value based on Project Finish Date (“Finish”): if the project...
Hi Bhatia,
Your formula turned out fine in my Project Desktop environment.
Try copying and pasting the formula into another custom field.
You can also try this other similar formula (copy and paste):
IIf([Finish]<cdate("7/1/24"),"FY24",IIf(month([Finish])>6,"FY" & right(year([Finish]),2)+1,"FY" & right(year([Finish]),2)))
I look forward to your comments.
Ignacio
Hi John-project:
Thanks for suggesting the date nuance. I will keep a note of that. In this case (see above example from today) when the date is 6/30/24, I get two different FY values.
Bhatia,
Sorry but I don't see any updates to your example. The latest finish date I see is 6/28/24 for several rows. Did you try Ignacio's custom field formula? It works great for me.
John