Solved

Date formula for showing last 2 days

Posted on 2011-02-24
2
362 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
Comment Utility
select * from dbo.completion_status
where

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

Author Closing Comment

by:srodgers45
Comment Utility
Perfect, Thanks for the help and quick response
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now