If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filter from a single date - Resolved

Started by cdndesi, 27 Jan 2011 11:58:28 AM

Previous topic - Next topic

cdndesi

Hi folks,

I have a DateTime Field that I would like to filter from a specific year, month and date.

It's running from a SQL Server 2000 Environment and utilizing Report Studio 8.2

The dataset runs from January 1st, 2009 to present. I want only data from December 27, 2010 to present to show in the report, and anything before to be filtered out.

I got started with:

RegistrationDateTime

RegistrationDate
CONVERT(VARCHAR(10), ([Physical Layer].[Package].[DateTimeField]), 110)

Which results in sample data in the following format: '20101226' (YYYYMMDD format).

When I try to filter on [RegistrationDate]>'20101226' (ie. Show everything starting December 27 2010 and onwards), it's still displaying all the numbers. Can anybody help?

***************************

LOL, looks like I was just a bit confused:

Accomplished it with taking the Datetime field "not between" 2009 and the other date.