Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

How I can create column that will hold current date dynamically?

  Asked By: Stevie    Date: Apr 01    Category: Sharepoint    Views: 17873

I want to create a column in a list that will hold the current date
dynamically. Is there any formular or function I can use for that?



5 Answers Found

Answer #1    Answered By: Octavio Dotson     Answered On: Apr 01

Absolutely. From a list, create  a new column. Make it a Date/Time data
type. At the bottom of the page, you'll see a radio button asking you
if you want to make the column's default today's date.

Answer #2    Answered By: Judy Pittman     Answered On: Apr 01

Keep in mind this will not always view as today's date  (in the question asked, I
took "dynamic" to mean this). It will always be the date that the item was
added (or edited).

Answer #3    Answered By: Tricia Mullins     Answered On: Apr 01

AFAIK, a list  item is static data. That is, it cannot "automatically" calculate
when someone is viewing the data or the data is being pulled for reporting.
Think of it as a record in SQL (in essence it is just that). A calculated
column is merely a way to calculate the data going into the column  prior to
storing it.

However, you could probably attach a workflow to the list that updates the list
item's "Current Date" column at 12:00AM every day.

Answer #4    Answered By: Himanshu Gohil     Answered On: Apr 01

Can you explain more about the workflow which will update "Current
Date" Column?

Answer #5    Answered By: Ashton Schroeder     Answered On: Apr 01

Unfortunately, you really can't. Calculated columns are processed when
an item is added or modified. So even if you create  a column  that
contains the current  date, it won't be updated each day, only when the
item is changed.