Flag Slow moving Model

[Anonymous]

Hi All

I have below Inventory table .

Last_sold.....Model

23/1/2019.....KL1184

23/1/2018.....KL1181

23/1/2017.....KL1182

23/1/2016.....KL1183

I like to Flag those slow moving Model more then 3 year.

Can some one share the expression .

Paul

[amitchandak · Accepted solution]

@Anonymous , A new column like

if([Last_sold] < date(year(today())-3,month(today()),day(today())), "Yes", "No")