Good luck then. :)

lior654#hotmail.com wrote: How can I use the DATENAME() function to get the name of the month? DATENAME() can accept a varchar as the date, so you can just create a random date, with the month as you want: DECLARE @somedate varchar(20); SET @somedate = '2005-01-01'; SELECT datename(month,@somedate); This will return "January". However, I would recommend that user interface type things like getting a month name are best carried out in the UI layer leaving the data layer to get on with things that it is good at (like manipulating the data in the database) My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius

Ok, well you could try something like: DateTime dtStart = new DateTime(2005, 1, 1); DateTime dtEnd = new DateTime(2005, 1, 30); DateTime dtCurrent = dtStart; while (dtCurrent < dtEnd) { double dDays; if (dtCurrent.DayOfWeek != DayOfWeek.Sunday) dDays = 6.0 - (double)dtCurrent.DayOfWeek; else if ((dtCurrent.Day + 6) <= dtEnd.Day) dDays = 6.0; else dDays = dtEnd.Day - dtCurrent.Day; Console.Write(dtCurrent + " - "); DateTime dtEndOfWeek = dtCurrent.AddDays(dDays); Console.WriteLine(dtEndOfWeek); dtCurrent = dtEndOfWeek.AddDays(1.0); } David

Have you reported this to MS? I believe a VS SP1 is in the wings. Kevin

dateTimePicker1.Value.ToShortTimeString();