[raelkun00]

This is the code to filter a date in datareport

drFilterReport.Show
    deFilterReport.rsOrders.Filter = "[OrderDate] >= #" & Me.txtFrom.Text & "# And [OrderDate] <= #" & Me.txtTo.Text & "#"

What I need is to count the number of a sunday.
For example: date from October 8,2012 to November 5,2012.There are 4 sundays. What is the code to get it?
Help me please.Thank you.

[leixnt]

use weekday() function & looping to count day from monday-friday

note:
weekday() to check what day is it.
return value (cmiiw)
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday

[BobRodes]

Or you can use the Weekdayname function if you don't want to use the number. This is the "brute force" approach. You can do it a lot more efficiently using a formula. Here's an interesting discussion on the subject.