I am using FM 12 Adv

I have 3 fields:

[startDate] [EndDate] [Duration]

Duration is a calculated field that subtracts StartDate from EndDate and if ENDDate is blank, substitutes get(CurrentDate). This works.

Problem: If [startDate] = October 20, 2012 and [EndDate ]="" then Duration = 3 days ... ok ( [EndDate] uses today's date.)

But, when I start the program tomorrow, it still shows 3 days when it should show 4 days.

Question: "Is there a way, withouot creating a layout with the 3 fields and looping through them to update them, to 'refresh' the calculation? I have tried going to the layout and doing a 'refresh window' and 'commit record' but ti doesn't work.

Thanks

Unstore the calculation

A calculation field that uses Get (CurrentDate) needs to be unstored.

The unstored idea works great... IF the duration field holds the unstored calculation and there is no error trapping in related scripts.

For example, I use the following On Exit script trigger scripts to do some error checking and I assign $$ variables to be used instead of field names. This works. But, when I set the clock ahead 10 days, and then start the app, I get this: (Notice the ? at the end. Plus, when the EndDate is empty, it is supposed to substitute get(CurrentDate))

StartDateExit ( Script Triggered )script:

EndDateExit (Script Triggered) Script:

This is the Duration function... (Modified Brian Dunning)