Dear All Precious programmer,

I have a problem in trying to get a list of a date including days in a table start from first day of the month to the last day of the month.
This date should not include the satuday and sunday.
and I should be able to pick up those date for query match.

for example the output should be:

1 2 3 4 5 6 7 8 9 10 11 12........................29 30 31
Thur Fri Mon Tue Wed Thur Fri Mon Fri

Any help would be appreciated.

I thank you very much.

8 Years
Discussion Span
Last Post by hirenpatel53

Show me what you have done so far?

if you have not done anything, show me your pseudo code.


Dear Finito,

Thank you for the reply,

I have use the code below at the moment, which is wrong. is there anyway to fix this.

              For LoopDate = -11 To 19
                  vDate = FormatDateTime(DateAdd(DateInterval.Day, LoopDate, Today), DateFormat.ShortDate).ToString
          <td align="center" nowrap colspan="7"><strong><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif, Tahoma">


Thank you very much for helping me


Edited by molivia03: n/a


take ref and try fro this code

Dim weekends As var =  New DayOfWeek()
	 DayOfWeek.Saturday, DayOfWeek.Sunday 

Dim calendarMonth As DateTime =  DateTime.Parse(“10/1/2008″) 
Dim totalDays As Integer =  DateTime.DaysInMonth(DateTime.Now.Year,calendarMonth.Month) 
IEnumerable<int> businessDays = Enumerable.Range(1, totalDays)
.Where(d => 
Not weekends.Contains(New DateTime(DateTime.Now.Year, calendarMonth.Month, d).DayOfWeek)
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.