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 |
|
urpalshu
Starting Member
21 Posts |
 Posted - 2006-04-18 : 19:35:08
|
| Hello I am working on a Report in SQL Server 2003I have a text box showing the date: textbox.Value =TODAY()Please could some body tell me how I could display the date for just the previous month.I want only the Month to be displayed.Thank you, |
|
|
snktheone
Starting Member
20 Posts |
Posted - 2006-04-24 : 03:12:00
|
| u can use Previous(Fields!Month.Value)but u can only use it on fields i dont know it you can use it on textbox values |
 |
|
|
|
|
|
DISPLAY Previous Month