3 Replies Latest reply: Jul 22, 2012 3:55 AM by Deepak Vadithala RSS

    Button Actions - Select in Field

      Hello,

       

       

      I have two date-related fields: day_of_year_activity (numbered 1-365) and day_of_year_lead_created (numbered 1-365).

       

      I am trying to create a button action will allow me to select values in a straight table only when: day_of_year_activity-day_of_year_lead_created=0...in other words, when the day an activity was recorded is the same day that the lead was created.

       

      To try and solve this problem, I created an expression named 1Day that says: =day_of_year_activity-day_of_year_lead_created

       

      I then tried to use a button, action, select in field to pick only the rows where the 1Day expression is 0. It is not working. I click on the button, and nothing happens. Can anyone help, please?

       

      Thank you!

      Stephen