locked
how i calculate if a list of holidays present or not in between the Start and End Dates RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi..everyone,

     

                      i am developing Leave management System using share point 2010 foundation,i need help here to count holidays is presents between Start date and End date.

                      i have holidays list like below,

                                   Title                     date

                                New Year                  1/01/2011

                                Christmas                 12/25/2011

     

     

                               and i have leave request form with both Start Date and End Date fields .....here how i calculate if holidays present or not in between the Start and End Dates.And if any presents then how i calculate the number of total Leave days requested by user.pls help me to find the answer for this scenario

     


    Charles Michel.B Lead Consultant Mobile:+91 9659730405 www.itbusinessnetworks.co.uk
    • Moved by Dustin Lee - MSFTMicrosoft employee Monday, August 29, 2011 7:31 PM Moving from SharePoint Online to SharePoint on-premise. (From:Microsoft Online: SharePoint Online)
    Saturday, August 27, 2011 11:06 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Charles Michel,

    I would suggest looking into the SharePoint 2010 formulas that are available if you haven't already. I have linked them below. While there are quite a few things that you can do through the calculated columns, it seems like it might be going into developmental territory. I'll move your post on to the SharePoint 2010 forum to gain some further visibility into this.

    http://msdn.microsoft.com/en-us/library/bb862071.aspx

    -Dustin

    Monday, August 29, 2011 7:30 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi Charles Michel,

    I would suggest looking into the SharePoint 2010 formulas that are available if you haven't already. I have linked them below. While there are quite a few things that you can do through the calculated columns, it seems like it might be going into developmental territory. I'll move your post on to the SharePoint 2010 forum to gain some further visibility into this.

    http://msdn.microsoft.com/en-us/library/bb862071.aspx

    -Dustin

    Monday, August 29, 2011 7:30 PM
  • Question
    Sign in to vote
    2
    Sign in to vote
    Considering your requirement and the formula capabilities of SharePoint, I feel this requirement cannot be addressed with OOTB. I would request you to setup a tiny event handler on adding/editing leave request to find the date difference and the existance of Holidays (stored in a seperate list/ source) to findout the actual days of leave.
    • Proposed as answer by Strong Driver Tuesday, August 30, 2011 6:13 PM
    Monday, August 29, 2011 8:29 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    hi Dustin Lee,

                            Very thanks to helping me to find the solution according to my request.

    Charles Michel.B Lead Consultant Mobile:+91 9659730405 www.itbusinessnetworks.co.uk
    Sunday, September 4, 2011 5:31 PM