Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
donalejandro61
Starting Member
4 Posts |
 Posted - 2012-07-17 : 02:07:28
|
| Hello,I am using ssrs 2005 I have three seperate fields OHORDM which is the month the second field is OHORDD the Day and OHORDY is the Year I do have these three seperate fields as a string parameter, but I want do use the datepicker. Does anybody knows how to do this when the user select the calendar/datepicker? Any guidance will help I am lost on this one. Thank you in advance. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-17 : 08:25:32
|
When you get the value of the date in your stored procedure or query, use the DAY, MONTH, and YEAR functions to get the day, month and year. For example, this will give you the day, month and year of today:SELECT DAY(GETDATE()),MONTH(GETDATE()),YEAR(GETDATE()) |
 |
|
|
|
|
|
Use datepicker in multiple parameter