Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Custom List (Date issue)

  Asked By: Colin Stephens         Date: Mar 20, 2006      Category: Sharepoint      Views: 285
 

What I am trying to achieve is to have a column
that will calculate the number of days between a date in another column
and
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
read
"3" today. When I check the same item tomorrow it should read "2".


Is there any way to accomplish this?

Tagged:        

 

8 Answers Found

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

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, 2006       

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
properly.

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

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, 2006       

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
"Today".
try out this , it might be solve ur problem..............

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

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, 2006       

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
entries..........

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

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, 2006       

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].