Trigger in tab

[#1]

I have this where clause in the script,

where NOT ( [Subspace Expire] < today() )  AND [Subspace Commence] <= addmonths(today(),12);

Instead of this where clause in the script can I put this as trigger in tab as I need to create another tab with the below trigger,instead of 12 months I have to put 36 months.

where NOT ( [Subspace Expire] < today() )  AND [Subspace Commence] <= addmonths(today(),36);

How can I do that ?

[sunny_talwar]

Are you wanting to replace Where with front end trigger?

[#3]

Ya...

[sunny_talwar · Accepted solution]

So I think you would need two select in field actions.

1) Subspace expire

='>=' & Date(Min([Subspace expire]), 'Subspace_expire_Field_Format') & '<' & Date(Today(), 'Subspace_expire_Field_Format')

2) Subspace commence:

='<=' & Date(AddYears(Today(), 3), 'Subspace_expire_Field_Format')

[#5]

Awesome....Thank you very much.