Progressive selection

[#1]

Hi,

I have to select all days from the First of the Year to today. I want that users click on button and selection is made. How can I do this?

[MK_QSL]

Add action to Button

Add

Selection

Select in Field

Field

Date

Search String

='>='&YearStart(Today()) & '<=' & Today()

[sunny_talwar]

You will need select in field action with the following Search String:

='>=' & Date(YearStart(Max(DateField)), 'YourDateFormat') & '<=' & Date(Max(DateField), 'YourDateFormat')

[#4]

Manish,

Your solution works. But I have another question:

I'm working mainly with years, months and weeks; how can I get the same action for these 3 fields?

[MK_QSL]

Can you elaborate little more on your requirements?

[#6]

Yes, here it is.

I want to see sales made between the First of the year and today, but I didn't loaded a Date field: instead, I've loaded 4 fields: year, month, week and day (monday, tuesday...).

Now, my purpose is to have a selection in each of this field. In other words, if I click this button, I get selection:

- 2015 in Year;

- from January to September in Month;

- from 1 to 37 in Week.

(days aren't a problem).