Date Calculations

[Dean Redding]

Hi,

I am trying to create a field for a statement report where it will automatically update the due date to be 7 days of the current date.

I use the "Get[Current Date]" field +7, but it only adds the date that I create the field.

For example if I create this field on the 20th Dec. the due date will be 27th Dec.

But when I print off a statement on the 30th Dec, the due date is still 27th Dec.

Its not updating the current date.

Can anyone give me a better solution?

Thanks,

Dean

[Lee Smith]

I think you need to unstore the calculation.

Your calculation should be

Get (CurrentDate) + 7

If unstored, it will change with the change in date daily.

HTH

Lee