Date Filter

[Anonymous]

I created a calendar, and I added a filter in my application with the dates of this calendar.

I wish use calendar dates as a filter for my data.

For example if the user chose the 01/01/2017 I have the sales of 01/01.

How do I proceed?

I think I have to use a variable but I do not know how

Someone can help me please ?

[shraddha_g]

What is the issue you are facing?

Do you want to display Sales of that selected Date?

Then you can try

Sum({<Date = {"$(=Max(Date))"}>} Sales)

[Anonymous]

No

in fact I want to select a period of activity.

Example: Sale between 01/01/17 - 03/03/17

[shraddha_g]

in Filter , you can search >=01/01/17<=03/03/17 and press Enter.

It will select all dates in between those 2.

Make sure that you give input in correct date format.

[Anonymous]

It's a very good idea.

But I wanted to use two filters StartDate, EndDate.

I will offer it to my manager if I can not find it.

[shraddha_g]

If you are using 2 filters then you can try

Sum({<Date = {">=$(=Max(StartDate))<=$(=Max(EndDate))"}>} Sales)

[arulsettu]

may be in calendar create field like

day(date_field) as day

and use it as filter