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 Site Sponsors
Go to NothingButSharePoint.com to see the latest content for SharePoint Power Users, IT Pros and Developers.Top 20 EUSP Commenters
Greg100 commentsFrank96 commentsNancy92 commentsJeff Jones75 commentsLee Reed75 commentseric73 commentsQuick Access (mouseover for article count)
2007 2010 Blog Calculated Column calendar collaboration column conference Content Editor Web Part Content Type Data View Web Part document library end user excel Javascript jquery libraries library list lists live live online Metadata MOSS online Outlook 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: