locked
Calculate Total Days from Start and End Date RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    working on leave workflow, on form i have three fields start date, end date and total no. of days. pls guide how do i calculate total no. of days requested for leave from get the difference of start and end date.

    thanks

    Tuesday, May 3, 2016 5:28 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi SharePointTech,

    You can create a calculated column named Totaldays, and set formula as “DATEDIF([Startdate],[Enddate],"d")”.

    The result:

    Thanks,

    Dean Wang

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Victoria Xia Tuesday, May 24, 2016 12:19 PM
    • Marked as answer by Victoria Xia Monday, May 30, 2016 11:16 AM
    Sunday, May 15, 2016 6:39 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    please check this post - parts: 2,3 and 4

    Let me know if you need more details

    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Tuesday, May 3, 2016 5:36 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi.

    i m using info path form 2013 where added startdate,enddate and totaldays. on selection of start and end date its show total days. for example start date 3-may-2016 and end date  5-may-2016 then total days should calculated as 2 days.

    pls guide how do i calculate in infopath

    thanks

    Tuesday, May 3, 2016 7:52 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Please below go through below links

    https://sharepointcreativity.wordpress.com/2012/03/14/calculate-the-difference-between-two-date-picker-controls-in-infopath-using-rules-and-formulas-no-code/

    http://www.infopathdev.com/forums/p/23234/96687.aspx

    Let me know if you need any help..

    Tuesday, May 3, 2016 8:03 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi SharePointTech,

    You can create a calculated column named Totaldays, and set formula as “DATEDIF([Startdate],[Enddate],"d")”.

    The result:

    Thanks,

    Dean Wang

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Proposed as answer by Victoria Xia Tuesday, May 24, 2016 12:19 PM
    • Marked as answer by Victoria Xia Monday, May 30, 2016 11:16 AM
    Sunday, May 15, 2016 6:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi SharePointTech,

    Is there any update?

    If my reply is helpful to you, you can mark as answer.

    Thanks,

    Dean Wang

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    Wednesday, May 18, 2016 8:46 AM