Forum Discussion

SebTsang's avatar
SebTsang
Frequent Visitor
5 years ago
Solved

How to filter rows in a table using values from two different columns

I am trying to set a filter on my table to only show rows where the createdon date is before the ticketcloseddate 
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    SebTsang , You can create a column and then filter for value

     

    if [createdon date]<=  [ticketcloseddate] then 1 else 0

     

    filter for 1

amitchandak's avatar
amitchandak
Super User
5 years ago

SebTsang , You can create a column and then filter for value

 

if [createdon date]<=  [ticketcloseddate] then 1 else 0

 

filter for 1