Solved

using the difference between date in sharepoint

Posted on 2011-03-09
4
471 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 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

11 Experts available now in Live!

Get 1:1 Help Now