Friday, 12 June 2009

Using [Today] in a Calcuated field

Without going into some development of a computed field, dont bother thinking about doing this, it is a useless concept (unless you want a static generation).

Using Today in a calculated field will only work out the calculation at time of save, and I also read a post that suggested using the Modified date to get the same effect.

Without going too much outside the box, there is not a lot I would encourage doing.
Using Designer some suggest manipulate the listview in an xslt template and use JavaScript to manipulate the date, but then you have to do this to all the views you have created as well as the detail view (dispform) and stop people creating more or personal views, which will be a big pain. From my own experience and of the flakiness of SharePoint Designer I managed to kill an entire list when trying to javascript the views in this way.

So in summary try to avoid using calculated fields if you want the value to be dynamic.

And dont worry about trying to use Today if you do want a value, use Modify.

I am just one man with a very narrow view on what can be done with SharePoint, but to make my job easier if SharePoint does not do it out the box then I dont really want to waste my time with getting into support and development for all the sites we run.

So long as the end user knows the constraints of the system out the box they tend to understand.

No comments:

Post a Comment