Getdate

[mix]

Hi
I am trying to create a report in which a user will just select their own club from a drop down list, once club is selected, i want all courses scheduled for that day to print - without the user selecting a date (i want today's date to be selected automatically). is GETDATE the right command for this?
Thanks.

[cweiss]

If you're referring to Access, the Date function will return today's date.

[mix]

HI
Thanks for the reply. This is using SQL Server Reporting Services. Any suggestions?
THANKS

[cweiss]

Ahh no experience with that, sorry :(