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.