I was looking at your article where you used jquery to replace the "Last Updated" Column (http://www.endusersharepoint.com/?p=1221) and I was wondering if you could write some jquery that would update a column to always have today's date in it.
Stump the Panel » End Users and Information Workers
create a pseudo [today] column
(8 posts)-
Joy
MemberPosted 2 months ago # -
Joy,
The jQuery solution only changes what appears on the screen--no data gets changed. It's just helpful to know that Last Modified was 20 days ago instead of mm/dd/yyyy. All we're doing is making the data on the page look different in relation to the current time.
So, I don't think a column of Today() would be of much value.
Posted 2 months ago # -
AdamCarr
MemberIm not sure if this is what your trying to achieve.
But you can trick SharePoint into allowing a calculated column to display the [Today] function.
Simply add a new column to the list called Today
Create a new calculated Column and name it to somethinging meaningful.
Set the formula to [Today] and set the type to Date/Time.
Delete the column created earlier named Today.
That should give you a calculated column of todays date in every row.Posted 2 months ago # -
Adam, I think the problem there is it will not show Today() the following day.
Posted 2 months ago # -
AdamCarr
MemberI see what you mean, it effectively records the created/modified date in that column...
Back to the drawing board for me then, thank you for letting me know :)
Posted 2 months ago # -
There are hacks to this that require programming but they essentially update the column every day with a timer job that forces the data to refresh. I prefer to just do my calculations on the screen.
Posted 2 months ago # -
Joy
MemberSo could I create a site column that has programming to put today's date in it? Then I could add this column to any list and then use it in any calculated column in that list that needs today's date.
Posted 2 months ago # -
I think that's the idea. I haven't implemented this myself--I try to avoid code and timer jobs. You may also check codeplex for any recent projects addressing this problem.
Posted 2 months ago #
Reply
You must log in to post.