How to use between condition in date field

[Anonymous]

Hi,

How to use between condition in date field.

i want to select the dates from 01/01/2007 to 31/12/2007.Kindly help me how resolve this issue.

[rubenmarin]

Hi Sathiskumar, you can set a filter like:

>=01/01/2007<=31/12/2007

[Anonymous]

Thank For Your Information

Kindly explain me where we want set this filter.

because i've use below method

Create two new variables…

vStartDate and vEndDate

Now go to Settings – Document Properties – Triggers

Variable Event Triggers

Select vStartDate

OnChange Add Action

Add

Select in Field

Field = Your Date Field

Search String = ='>='&vStartDate & '<=' & vEndDate

Do the same for vEndDate

But is not working.Kindly help me.

[AbhijitBansode]

Check value of variable in text object.

If it is appearing as a number, then you have to use below:

='>=' & Date(vStartDate) & '<=' & Date(vEndDate)

[Anonymous]

No it is date format only.

I think onChange Event not trigger.

Kindly advise me.

[rubenmarin]

Hi Sathishkumar, anyway, can you try what Abhjit said?, it's very usual that Qv internally uses a different value format than the one you see.

[Anonymous]

I tried that method but it is not working.Any other idea.

[rubenmarin]

It's working for me, please check attachment and look what you have different