Show date if inside selected date range?

[#1]

Hi!  I hae this colomn first_order_date and want to show it in my result table only if it's inside the selected date range.

For example:

product a s first_order_date = 2014-02-12

my selection of dates is 2014-01-01 to 2014-03-01

then i want to show first_order_date

but if my selection of dates is 2014-04-01 to 2014-05-01 i dont want it to show.

any ideas?

[antoniotiman]

Hi Rickard,

Your selection date is from List Box or Date_Start and Date_End ?

[#3]

Its actually from 3 listboxes, using year, month, day,

[mjayachandran]

Just Create two new variables… like  "vStartDate" and "vEndDate"

then 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

same for 'vEndDate'.

In Input Box , add these two variables, Go to number tab and make sure that the formatting of vStartDate and vEndDate is same as your Date Field….

[jonathandienst]

Hi

You may be able to use something like:

     =Sum({<first_order_date = P(day)>} value)

HTH

Jonathan

[tresesco]

How are the date field related? It would be easier to help if you could create a sample qvw and share.

[antoniotiman]

See attachment.

Thet is a starting point.