Date filter doesn't work

[#1]

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!

[MK_QSL]

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')

[#3]

Just try, no luck, still doesn't filter right.