Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Date Range selection

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
1 Reply

Re: Date Range selection

May be try this as your search string:

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

Community Browser