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 |
|
JJ297
Aged Yak Warrior
940 Posts |
 Posted - 2010-04-29 : 11:31:31
|
| How do I write an expression for this in a Derived Column. I tried this but it's not working:GETDATE() -3 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-04-29 : 11:40:14
|
| (DT_WSTR,30)(DT_DBDATE)(dateadd("d",-3,getdate())) |
 |
|
|
JJ297
Aged Yak Warrior
940 Posts |
Posted - 2010-04-29 : 11:52:55
|
| Thanks I just found this on the internet:DATEADD("day", -3, GETDATE())Do I need to add this?(DT_WSTR,30)(DT_DBDATE) what's it for? |
|
|
|
JJ297
Aged Yak Warrior
940 Posts |
Posted - 2010-04-29 : 13:23:09
|
| Okay I got it, you are telling me it's for the Data Type.Thanks! |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-04-29 : 14:24:33
|
| Np. You're welcome. |
|
|
|
|
|
|
GetDate question