Forum Discussion

duongan1602's avatar
duongan1602
Regular Visitor
4 years ago

Filter date/month satisfy complex condition

Hi I have a table like this:  Date Customer Amount 15-Mar C 200 1-Apr A 100 26-May B 200 18-Jun C 300 13-Jun A 100   My problemn is, for each Customer, i need to ...
Need Help
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi duongan1602 

 

Currently there is no year in your sample data. To compare dates with today, you need to have Year/Month/Day for date values. 

 

In addition, how to understand the condition "also 2 or 3 months ago, he didn't buy it"? In the current sample data, customer A and C bought the item twice. Which month should be returned for them? You can provide some examples with dummy data to explain the output result. This can help us understand it better. 


Best Regards,
Community Support Team _ Jing