Date Range selection

[#1]

Hi All,

I have Date in MMDDYYYY format, I am trying get all dates less than 1st July 2014, But dates are not selecting properly.

I am trying to do as:

1. Created new Input box with Pre-July

2.In Number tab created date format as needed,(MMDDYYYY)

3. Created the Variable trigger

But dates are not selecting as expected, Please find the attached for the steps I am trying to do.

Please advise me.

Header 1

[sunny_talwar]

May be try this as your search string:

='<=' & Date(MakeDate(2014, 6, 30), 'M/D/YYYY')