Forum Discussion
Flag Slow moving Model
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
Anonymous , A new column like
if([Last_sold] < date(year(today())-3,month(today()),day(today())), "Yes", "No")
1 Reply
Anonymous , A new column like
if([Last_sold] < date(year(today())-3,month(today()),day(today())), "Yes", "No")