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 |
|
leslieb
Starting Member
23 Posts |
 Posted - 2009-01-14 : 20:23:04
|
| I have many reports that get updated each morning with the previous day's data (the data is imported from Excel). The reports have in the header the report name and a date field. The date field has '=Today' but the data is actaully the previous day's balances. I want to have the report show the date of the data ie Today less 1 day.Is there a way I can do this knowing that the data does not have a date in it? |
|
|
revelator
Starting Member
32 Posts |
Posted - 2009-01-15 : 05:15:05
|
| Use this expression in the header.=dateadd("d",-1,today())-----------------------------------Waiting for the Great Leap Forwards |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 07:46:45
|
| or even=dateadd("d",-1,Now()) |
|
|
|
leslieb
Starting Member
23 Posts |
Posted - 2009-01-15 : 17:07:53
|
Both work fine. Many thanks for the information.  |
|
|
|
|
|
|
Previous Day Date in Header