Forum Discussion
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
For some reasons I am not seeing my replies from yesterday and today. I think I will create another thread and post my reply there...
Bhatia,
Why start a new thread, your latest reply is here. Are you looking in the "most recent" category of postings?
John
