Solved

using the difference between date in sharepoint

Posted on 2011-03-09
4
478 Views
Last Modified: 2012-05-11
Dear Sir

i have a simple question
i create a workflow in sharepoint server and i want to return the difference in number of days between the due date to a following task and the current date.
i create a new column name time left.
so if the due date of a task is 15-3-2011
and the current date is 12-3-2011
i want the time left column to return 3
(15-12 =3)
i think it is a simple question but i can't figure how do it

Regards
0
Comment
Question by:spring80
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
Hairbrush earned 500 total points
ID: 35095226
If you have a column in your task list called Due Date then your Time Left column should be a calculated field and your formula should be [Due Date] - [Today]

Is that what you want to achieve?  Please correct me if I have understood what you are trying to do.
0
 

Author Comment

by:spring80
ID: 35101320
yes it is what i need but this formula not work for me
0
 
LVL 12

Expert Comment

by:Hairbrush
ID: 35106393
Try it without the spaces.
0
 

Author Closing Comment

by:spring80
ID: 35230273
Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

4 Experts available now in Live!

Get 1:1 Help Now