Triggers - actions: select from date & exclude date in selection

[#1]

Hello all,

I have go a sheet in my application where a want to show tables and graphs from a certain date (01/11/2016).

I managed to do this with Onectivate Sheet - Action  : select in field.

='>=' & Date

This gives me the tables and graphs for the period I want.

In the data however is one particular date (31/01/2017) that I want to exclude from this sheet.

Is there any way I can integrate this in the trigger?

Thx.

[Anil_Babu_Samineni]

We have On Activate Sheet with Select in Field and then Select Excluded option

For Ref, PFA

[#3]

I tried that but Ididn't seem to work.

Can you write the solution in text because I am on personal edition for the moment and I cannot open your qvw.

[Anil_Babu_Samineni]

Can you describe more, And try to add application. Then tell me what you are doing over there. So that, I can paste on wall. It would better to move

[vinieme12]

After the Action to Select dates ='>=' & Date add another action

Select in Field > Toggle Select  : Add field name and string as the date

[Anonymous]

this might work in expressions or by setting a variable

=Only({<DATE-={'(31/01/2017'}>}DATE)