"Chris Patten" <Chris Patten@discussions.microsoft.com> wrote in message
news:97123E93-2186-4AE4-9072-A2800C527EE0@microsoft.com...
> I have a report that I always have to set the 2 date criteria fields to

"Ravi Mumulla (Microsoft)" wrote:

> =DateSerial(Year(Now), Month(Now), 1) for first day of the month and
> =DateSerial(Year(Now), Month(Now)+1, 0) for the last day of the month.
>
> --
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Chris Patten" <Chris Patten@discussions.microsoft.com> wrote in message
> news:97123E93-2186-4AE4-9072-A2800C527EE0@microsoft.com...
> > I have a report that I always have to set the 2 date criteria fields to
> the first day of the month and to the last day of the month....I'm sure
> there's a function that I can set as a default in the report designer??
> Possible?
>
>