Forum Discussion

Bhatia's avatar
Bhatia
Copper Contributor
Nov 12, 2024
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...
office 365
Online
Project
project web app
  • Ignacio_Martin's avatar
    Ignacio_Martin
    Nov 13, 2024

    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

Ignacio_Martin's avatar
Ignacio_Martin
Iron Contributor
Nov 13, 2024

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

John-project's avatar
John-project
Silver Contributor
Nov 13, 2024

Ignacio_Martin,

I like your approach, instead of a lengthy formula, you created an algorithm that is short, concise and will work for several years.😀

John

Resources