AnsweredAssumed Answered

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

Question asked by firth5 on Apr 19, 2011
Latest reply on Apr 19, 2011 by raybaudi

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?  

Outcomes