"Ben Watts" wrote:

>
> try this
>
> =cdate("01/01/"+cstr(year(today)))
> it basically just adds the current year to 01/01/ and changes it all to date
> format
>
> "randy1200" <randy1200@newsgroups.nospam> wrote in message
> news:BCCE7BA4-7E34-4D5B-BBB2-5555142D8A1E@microsoft.com...
> >I have my Reporting Services Report open in Visual Studio2005. I have the
> > layout view selected, which makes the Report Menu available at the top of
> > Visual Studio 2005 (File, Edit...Report). Under the Report Menu, I've
> > selected Report Parameters.
> >
> > I have the values StartDate and EndDate. For EndDate, I have
> > =Today
> > under Non-quired Default values, and that works great.
> >
> > For StartDate, I have
> > =DateValue("01/01/2006")
> > This works okay for the moment, but I'd really like to do something like
> > =DateValue("01/01/" + Year)
> > This doesn't compile because DateValue only accepts one parameter. Any
> > ideas
> > how to edit the expression so that the year is always the current year?
> >
> > Thanks,
> > --
> > Randy
>
>