Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • Last Modified:

using the difference between date in sharepoint

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
spring80
Asked:
spring80
  • 2
  • 2
1 Solution
 
HairbrushCommented:
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
 
spring80Author Commented:
yes it is what i need but this formula not work for me
0
 
HairbrushCommented:
Try it without the spaces.
0
 
spring80Author Commented:
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now