?
Solved

MS SQL Report services: todays date, minus a day

Posted on 2009-05-11
5
Medium Priority
?
1,370 Views
Last Modified: 2012-05-06
Hello all. I need to

I am working with Microsoft SQL 2005 Report services and need to create a basic expression and have completely forgotten how to create todays date minus one day.

Thanks in advance!
0
Comment
Question by:tonypjones
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 3

Expert Comment

by:SalmanZG
ID: 24356957
select DATEADD(D,-1, getdate())
0
 
LVL 1

Author Comment

by:tonypjones
ID: 24357039
I need to input this directly into the edit expression text box. I tried inputting select DATEADD(D,-1, getdate()) and replaced the "select" with a = but it did not like the "D".
0
 
LVL 3

Expert Comment

by:SalmanZG
ID: 24357211
Can you try this:
DateAdd(DateInterval.Day, -1, Today())
0
 
LVL 16

Accepted Solution

by:
Auric1983 earned 2000 total points
ID: 24357239
You can also try this

=Today().AddDays(-1)

0
 
LVL 1

Author Closing Comment

by:tonypjones
ID: 31580244
That was it! I knew it as soon as I saw it. Thanks Auric1983
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question