Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 m...
  • amitchandak's avatar
    5 years ago

    Anonymous , A new column like

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