Forum Discussion
Inconsistent Values from PWA Custom Field Formula
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
Bhatia,
I can't explain why some values are showing up as blank but I can give you some insight about your formula.
Remember that dates in Project are not just date values but also include the time, regardless of how a date is displayed in a view. So 6/1/24 is actually 6/1/24 8:00 AM if a start date and 6/1/24 5:00 PM if a finish date, assuming the Standard calendar. However, when the CDate function is applied to a date such as 6/1/24, it produces 6/1/24 12:00 AM. Attempting to use a "greater than or equal to" or "less than or equal to" operator in a custom field formula needs to take the time factor into account.
Hope this helps.
John
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
