Solved

Date formula for showing last 2 days

Posted on 2011-02-24
2
372 Views
Last Modified: 2012-05-11
I would like to show in a query data for the previous 2 days when the report runs. Any ideas? New to SSRS usually use Crystal. Not to proficient in writing queries yet, more drag and drop.

Thanks
Date Query
0
Comment
Question by:srodgers45
2 Comments
 
LVL 16

Accepted Solution

by:
santoshmotwani earned 500 total points
ID: 34975557
select * from dbo.completion_status
where

dbo.completion_status.tdate > = getdate () - 2
0
 

Author Closing Comment

by:srodgers45
ID: 34975596
Perfect, Thanks for the help and quick response
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Columns as Rows in a Table 14 54
sql query to reportserver  table error 3 51
Publishing SSRS Reports to an IIS Server 3 76
SSRS 2016 Rendering HTML tables 3 31
Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

820 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