Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Custom List (Date issue)

  Asked By: Colin    Date: Mar 20    Category: Sharepoint    Views: 1137

What I am trying to achieve is to have a column
that will calculate the number of days between a date in another column
the date that the item is being viewed, not when the item is created.

To illustrate: If Column1 contains the date 8/19/05, Column2 should
"3" today. When I check the same item tomorrow it should read "2".

Is there any way to accomplish this?



8 Answers Found

Answer #1    Answered By: Ana Payne     Answered On: Mar 20

I have been investigating the Display Current date  issue on the Custom
List. [Today] does not work. Is there any way I can display current date
on the Custom List Column without create a View?

Answer #2    Answered By: Laura Walker     Answered On: Mar 20

create a new field "Today" in custom  list . now use this list  in your
calulated field formula by using [Today] u can calculate  the difference
betwn 2 dates. later u can delete the "today" field. it 'll work

Answer #3    Answered By: Lacey Daniels     Answered On: Mar 20

Can you tell me how to display
only the Current Date? In on a field in Custom List.

Answer #4    Answered By: Megan Martin     Answered On: Mar 20

thr is a function [Today] for current date  , but by default we cant use
this function into the list  formula .
so u first add a new field and named it "Today". and then create a
formula for ur current date field and include [Today] in that formulla ,
once u successfuly craeted this formula u can delete the field
try out this , it might be solve ur problem..............

Answer #5    Answered By: Donta Kirkland     Answered On: Mar 20

I am not sure but is this a bug from Sharepoint.
created  Today Field and added it on Current Field Formula. It took it
without error. I removed today  field and the date  worked. I am able to
get the Serial Number of the date, But the date is not getting changed
based on the Access Date. Suppose today's date is 17/04/2006 so tomorrow
when I open the portal it should show me 18/04/2006....

Answer #6    Answered By: Cade Velazquez     Answered On: Mar 20

this may be an issue  with SP. i dont think tht this solution may work
for existing entries in the list. it 'll work only for new

Answer #7    Answered By: Ariana Christensen     Answered On: Mar 20

Create a Column Name "Today_Date"
Check on "Date and Time" for the (Type of Information)
Select Default value as Today's Date.

I hope this will solve you.. you will gete this column as today'date.

Answer #8    Answered By: Darrius Whitfield     Answered On: Mar 20

I am going ahead developing a web part to do this.........

Didn't find what you were looking for? Find more on Custom List (Date issue) Or get search suggestion and latest updates.