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 |
|
jess1984
Starting Member
14 Posts |
 Posted - 2010-10-11 : 05:40:09
|
| Hai, deployed a report in ssrs report server and passing the Date as parameter, default it will be current date. when i deployed the report. actuall current date is 11-Oct-2010 but in report it showing as 10-Nov-2010 any solution to get current date as default ?Thanks in AdvanceJessjess1984 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-10-11 : 08:32:56
|
| while passing send the date as in this mm/dd/yyyy format |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-10-11 : 08:57:37
|
| what??? don't just swap stuff around and hope for the best.stick to standard iso datetime strings and there can be no confusion.The only *guaranteed* strings for dates are:1) Short Form YYYYMMDD : So 11-oct-2010 is '20101011'2) Long Form YYYY-MM-DDTHH:MM:SS.MSS : So 11-Oct-2010 is '2010-10-11T00:00:00.000'Don't use anything else. If you do then you are at the mercy of whatever local / language setting you are running on.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
Date format Issue