Cant Grasp datasources and select function


I appreciate your support, I have spent many days in this problem, something escape my understanding.

My problem is very typical, I have number of "DEALS" and "ADD_DATE". I just want to filter out DEALS that were ADDED this quarter. So I tried doing the following function:

I have tried the following reference recommending SELECT function https://support.klipfolio.com/hc/en-us/articles/360011416893-Klipfolio-functions#BETWEEN


But the problem that data is not correct, its not corresponding to the. first column. 

All I want to accomplish is simply have |DEAD| with |ADDED DATE| Within the last quarter.


Appreciate the help





1 comment

  • 0
    Meggan King

    Hello - 

    This is a great question. I think to understand we would need the support team to look at your Klip, but generally, if SELECT isn't working it means there is a formula or data alignment issue. Do you have the same SELECT and BETWEEN condition in your column for add_date? 



Please sign in to leave a comment.