Notes: View doesn't refresh

Symptoms:

• permanently shows the Refresh Icon

• the "NoCache" parameter on the dblookup "doesn't work"

• the view.Refresh statement doesn't refresh the view

Problem:

The view probably uses @Now or @Today formulas in the Selection Formula or in a column, which prevents the view's index to be updated (it's always out-of-date as these formulas force the calculation to go to the minute:second detail).

Solution:

Use this formula instead: @TextToTime("Today") - it calculates only to the year-month-day so that the index only updates once a day.