2 Replies Latest reply: Feb 25, 2015 12:47 PM by Suzanne Wong RSS

    Date filter doesn't work

      I am having problem where when i enter the date from 11/01/2014 through 11/09/2014 in my input box, it only pulls data from 11/01/2014-11/08/2014....it doesn't pull data that dated 11/09/2014.

       

      What am i missing?

       

      In the Load statement, i have it set as:

      LOAD

      Date("CollectorAudit.DateActionCompleted",'MM/DD/YYYY h:mm:ss[.fff] TT') as "Action Completed",

       

       

      In my Chart properties for the date dimension i have it set as

      =Date(if([Action Completed]>ActionCompletedFrom and [Action Completed]<ActionCompletedTo,[Action Completed],""))

       

      in the Document Properties > Triggers > variable Event Trigger for date i have it set to

      ='>=' & ActionCompletedFrom &' 12:00:00 AM' & '<=' & ActionCompletedTo &' 11:59:59 PM'

       

      Any help will be greatly appreciated....Thanks!