So hopefully I can explain this and make sense. So what I want to do is see if a customer made a purchase in the same year they joined the rewards program. So lets say Rewards Join Date is 01/04/2018 and their first purchase was 08/26/2018. What I would like to be able to do is if the purchase date is in the same year as the Rewards Join Date then return the response in a column that says “Purchase in Rewards Join Year.”
Would the basis of this be something like SWITCH TRUE()?
If so I know about using “&&” but how would I go about saying between two dates for Rewards Join Date and then doing it again for their First Purchase?