Solved

using the difference between date in sharepoint

Posted on 2011-03-09
4
511 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

636 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