Jake. I think with the @TextToTime method the view needs to be updated each day to make it work - i.e to pick up the correct date again. So I suppose a nightly agent that just refreshes the view would do this? My test worked because the view has a selection of creation date >= @textToTime("Today"). I guess this view will be incorrect tomorrow unless the index is refreshed (i.e it will still have todays date in)
Jake. I think with the @TextToTime method the view needs to be updated each day to make it work - i.e to pick up the correct date again. So I suppose a nightly agent that just refreshes the view would do this? My test worked because the view has a selection of creation date >= @textToTime("Today"). I guess this view will be incorrect tomorrow unless the index is refreshed (i.e it will still have todays date in)