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 |
|
v_kash
Starting Member
45 Posts |
 Posted - 2009-05-05 : 15:18:21
|
| hello - i have a date parameter (@enddate). if i choose '5/4/09' from my dropdown, i would like an expression to show '4/5/08'anyone have a clue how to do this? i tried using datediff, but keep getting an error |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-13 : 11:12:23
|
| why use dropdown? just make parameter type datetime and you will automatically get calendar popup. then to get your value, just useDateAdd("yyyy",-1,Parameters!Enddate.value) |
 |
|
|
|
|
|
parameter help