Using Get(CurrentDate) to determine the # of weeks on a project
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?