4 Replies Latest reply on Apr 19, 2011 10:57 AM by raybaudi

    Using Get(CurrentDate) to determine the # of weeks on a project

    firth5

      Title

      Using Get(CurrentDate) to determine the # of weeks on a project

      Post

      I've got a calc field that tells me how many weeks after the start date of a project (d_StartProject) we are each day, and I display this on a daily report:

      Floor(((Get(CurrentDate) - d_StartProject) / 7)  +  1)

      I have the field Indexed. 

      The calc seems to be working.  However, it doesn't always update when I run the report.  I seem to have to do any sort of modification on the database before the calc updates.   What am I doing wrong?