Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try below
='>=' & TimeStamp#(ActionCompletedFrom &' 12:00:00 AM','DD/MM/YYYY hh:mm:ss') ,'& '<=' & TimeStamp#(ActionCompletedTo &' 11:59:59 PM','DD/MM/YYYY hh:mm:ss')
Just try, no luck, still doesn't filter right.