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 |
|
osirisa
Constraint Violating Yak Guru
289 Posts |
 Posted - 2008-03-05 : 13:59:24
|
| Hi Group:I need help building a date Expresion using Reporting Services 2005. Here is an example:=DateAdd("m", -1, DateSerial(Year(Now()),Month(Now()),Day(NOW())))This doesn't work. I need the previous month and the current year.For example we are now in 03/05/ 2008 - I need 02/2008.Thanks for the help |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2008-03-05 : 14:09:15
|
| What about for 01/01/2008 ??"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
osirisa
Constraint Violating Yak Guru
289 Posts |
Posted - 2008-03-05 : 14:13:13
|
| Thank You, It's working now....:) |
|
|
|
|
|
|
Date Expression