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

Date Filter not working

Started by Vick, 14 Apr 2015 12:20:38 PM

Previous topic - Next topic

Vick

I have a database column Audit_Close_Date which is of date datatype with values as below

3/6/2009
11/28/2011 8:51:01 PM
2/26/2009
6/21/2010 4:23:35 AM
4/2/2012

I am creating a date prompt in Report Studio and filter my query using [Audit_Close_Date] > ?Date_Parm?

It does not give me error but does not filter right, it always gives me blank result vs I know that data exists in database.

If someone could please tell me what is wrong with my filter, i tried both date and date time prompt but no luck

-Vic