Todays date what % between start and due date

[ibiubu]

I have a field with a start date, and a field with a due date. I want a field that shows a % for how far along todays date is between the start and due date fields.

I thought I had a calculation that would do this, but it will not update. The only time it updates is if I change the date in either the start or due fields.

Anyone have a calculation that will continually work for this?

LR

[comment]

Make the calculation unstored.

[Søren Dyhr]

The reason it won't update is that the field is stored, making it unstored does the trick - but If you need to make it sotred for keying purposes use Evaluate( in an autoenter with updating chosen.

--sd