Hello,

I'm trying to get the week ending and month ending dates of approximately 4 weeks past today's date. I have written some code that gets the date for last sunday, but does not go past that. If anyone can help me out I would appreciate it. Here is the code:

           TimeSpan oneDay = new TimeSpan(1,0,0);
            Calendar calendar = info.Calendar;
            DateTime dtNow = DateTime.Today;
            dt = new DateTime(dtNow.Year, dtNow.Month, dtNow.Day, calendar);
                        int count = 0;
             dt.Month);
                        int x, y;
            for (x = 0; x <= 3; x++)
            {
                while(!dt.DayOfWeek.Equals(DayOfWeek.Sunday) && (dt.Day != eom))
                {
                    dt = dt.Subtract(oneDay);
                    eom = DateTime.DaysInMonth(dt.Year, dt.Month);
                }
                endingDatesList += dt.ToShortDateString() + ", ";
                for (y = 0; y <= 25; y++)
                {
                    dt = dt.Subtract(oneDay);

                }
            }

Thanks!

*******(*)*******

__________________
*******(*)*******

Ok. I think I've got it now. I changed the code because someone here helped me see what could be done from a different angle and I put code behind it and it worked. You tend to get tunnel vision sometimes and need a kick in a different direction to help.

TimeSpan oneDay = new TimeSpan(1,0,0);
            Calendar calendar = info.Calendar;
            DateTime dtNow = DateTime.Today;
            if(!dtNow.Month.Equals(1))
            {
                dt = new DateTime(dtNow.Year, dtNow.Month - 1, dtNow.Day - dtNow.Day + 1, calendar);
            }
            else
            {
                dt = new DateTime(dtNow.Year - 1, dtNow.Month + 11, dtNow.Day - dtNow.Day + 1, calendar);
            }
            int count = 0;
            int eom = DateTime.DaysInMonth(dt.Year, dt.Month);
            while(count < 15)
            {
                // insert to endingDatesList when date is Sunday or End of Month
                while(!dt.DayOfWeek.Equals(DayOfWeek.Sunday) && (dt.Day != eom))
                {
                    // add one day to the date.
                    dt = dt.AddDays(1);
                    eom = DateTime.DaysInMonth(dt.Year, dt.Month);
                }
                endingDatesList += dt.ToShortDateString() + ", ";
                count++;
                dt = dt.AddDays(1);
            }

Thanks anyway. Hope this helps someone else too.

*******(*)*******