Skip to main content
Solved

Filter Report by Date Parameter

  • 22 August 2023
  • 2 replies
  • 91 views

I have created a Date Parameter for a custom report.  I am trying to filter the report by this parameter, the result is coming back with no data (a blank report).  I am selecting a date that i am 100% sure is in the dataset because i have a raw dump of the data.  What am I missing, why is my filter not working?  Does this have something to do with the values being seen as text instead of date?

 

2 replies

S
Rank
Userlevel 1
Badge

@sspencer I had the same problem in a GI. It could be possible, that you cant EQUAL a date because it stores the time as well if i am not mistaken. Try to build a second parameter and work with GREATER THAN and the other parameter with LESS THAN. Or try it with GREATER THAN OR EQUAL with the current paramter.

ThasinduRanasinghe61
Rank
Userlevel 2
Badge

@sspencer in the filter section the final line you have used @Date_parameter equal ‘blank’. May be try after deleting that line or add the required value there.

Reply


Terms & ConditionsCookie settings