Apply logic to button

[cbaqir]

I have a field called ACTIVITY_CODE and a field called ACTIVITY_END_DATE.

I also have  button called 'Active Financial View' in which a bookmark is applied. In addition to the bookmark, I want the data to display for ACTIVITY_CODE in which ACTIVITY_END_DATE>=today(). How can I apply this logic to this button?

Thanks,

Cassandra

[sunny_talwar · Accepted solution]

May be use a select in field action where you set ACTIVITY_END_DATE with a search string:

='>=' & Date(Today(), 'YourDateFieldFormatHere')

[cbaqir]

Thanks!

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny