Selecting multiple dates

[#1]

Hello,

I was wondering, if its possible to select a month on a calendar, and do a trigger that would select all the dates from that month and smaller ones?

Any ideas?

Do i make myself clear?

thanks

[Nicole-Smith]

Doesn't this solution from before work for you? Selecting Dates

[#3]

Its different now, I solved one problem with last time solution, but now its different.

I have a table with the Field Date.

Using that field, i create a calendar table with all the months and days.

Now i want to be able to click a month or a day from this calendar table and have the selection of the date.

Is this possible?

[Carlos_Reyes · Accepted solution]

An alternative would be to use Set Analysis. Something like the next:

Sum (  { $ < DateField = { " <= $(= Max( DateField ) ) " } > } AmountField)

So... it doesn't matter if you select only one date, the complete month or several months, this set analysis will consider all dates smaller than the max selected or possible date.

[#5]

Could you specify more?

Im imagining thats the search string on the triger at the month field?

[#6]

And what you mean by amount field?

[Carlos_Reyes]

Review the attached. I made an example of my previous suggestion.

Hope it helps!

[#8]

Hello, I was wondering if you could aid me with the syntax if i want it to be in a range of date, like <= max date but also bigger than today.

thanks

[Carlos_Reyes]

Mmm...

I'm not so sure about your range... because it'll only be possible if you have dates ahead of  today, but if you do, then this will do it.

Sum ( {$< Date={"> $(=Today()) <=$(=Max(Date))"}, MonthYear=>} Amount)

Hope it's useful.