Default Date

Hi,

I have two parameters as StartDate and End Date. these dates are picked from the Datepicker.

What I want to do is to default the start date to the the 1st January of the current year and end date as 31st december of the current year.

I tried to use the default in 'Report Parameters'. But could not get through. Can anyone suggest me the solution.

regards

Josh

Under default values of the report parameters are, you can use expressions to create your default dates (using non-queried option)

EG, 1 Jan in current year, expression would be

=DateSerial(Year(Today),1,1)

and 31 Dec

=DateSerial(Year(Today),12,31)

|||

Hi Will,

Thanks a lot! This worked and was very helpful.

Regards

Josh