AnsweredAssumed Answered

Calculated value wrong in a field.

Question asked by sam.gordon on Nov 19, 2018
Latest reply on Nov 21, 2018 by jackrodgersjr

Help with a simple calculation.  I have a global field to calculate the current week of the year.  This is the formula used - WeekOfYearFiscal ( Get ( CurrentDate ) ; 7 ).  Every now and then when I open the app, this calculation is showing the wrong week.  Today for instance it shows the week to be 40 when in fact it is 47.  In the Data Viewer I copied the formula directly from the field and monitor it.  It shows 47, but the field itself is not.  I am sure it has something to do with how the field is storing or indexing or something but I can't figure it out.  What would cause this?

 

Sam

Outcomes