Solved

Date formula for showing last 2 days

Posted on 2011-02-24
2
369 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

770 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