Discussion Board for collaboration related to QlikView Deployment.
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.
May be try this as your search string:
='<=' & Date(MakeDate(2014, 6, 30), 'M/D/YYYY')