Link to home
Start Free TrialLog in
Avatar of spring80
spring80

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Hairbrush
Hairbrush
Flag of Jersey image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of spring80
spring80

ASKER

yes it is what i need but this formula not work for me
Try it without the spaces.
Thanks