/// <summary>
        /// GetEndOfWeek
        /// </summary>
        /// <param name="myInputDate"></param>
        /// <returns></returns>
        public static DateTime GetEndOfWeek(DateTime myInputDate)
        {
            try
            {
                DayOfWeek myDOW = myInputDate.DayOfWeek;
                if (String.Compare(myDOW.ToString(), "Monday") == 0)
                {
                    myInputDate = myInputDate.AddDays(5);
                }
                else if (String.Compare(myDOW.ToString(), "Tuesday") == 0)
                {
                    myInputDate = myInputDate.AddDays(4);
                }
                else if (String.Compare(myDOW.ToString(), "Wednesday") == 0)
                {
                    myInputDate = myInputDate.AddDays(3);
                }
                else if (String.Compare(myDOW.ToString(), "Thursday") == 0)
                {
                    myInputDate = myInputDate.AddDays(2);
                }
                else if (String.Compare(myDOW.ToString(), "Friday") == 0)
                {
                    myInputDate = myInputDate.AddDays(1);
                }
                else if (String.Compare(myDOW.ToString(), "Sunday") == 0)
                {
                    myInputDate = myInputDate.AddDays(6);
                }
                return myInputDate;
            }
            catch (Exception exc)
            {
                Logger.Instance.Debug("Could not modify date: ", exc);
            }
            return myInputDate;

        }