More searching didn’t turn up any other solutions. I tried various vbscript/excel functions in the calculated field to no avail. Then I started thinking clientside. I figured that if I could identify the fields in the list display, I should be able to manipulate them with jQuery. A quick search turned up a nice little piece of code by Paul Grenier on EndUserSharePoint.com. He has written a series entitled jQuery for Everyone and one of his articles was on Replacing [Today]. In his article, Paul talks about replacing a DateTime field with an Aging calculation. His article calculates a DateTime from the last modification date.
-
Free eBooks, Web Parts and Solutions
Signup up for the EUSP Weekly Newsletter Quick Access (mouseover for article count)
2007 2010 Blog Calculated Column calendar CEWP collaboration conference Content Editor Web Part Content Type Dashboards Data View Web Part document library end user excel Javascript jquery libraries library list lists live live online Metadata MOSS online Permissions Screencast seminar sharepoint SharePoint 2010 Sharepoint Designer sharepoint saturday sharepoint training solutions template training Twitter video web part Web Parts Workflow workshop wss xsl-
Meet me at these events: