1 Reply Latest reply on Feb 14, 2019 11:04 PM by Shinichiro Murakami

    Date Add Calculation Status Change

    Vandana Samtani

      Hi Guys,

       

      I need your help in this request below -

       

      We received data by day for no of units sold by each part for different countries.

      The business wants to create a status field based on the date.

       

      Logic - If the part is launched then first 7 days the status will be new else Old.

      Every country has a different launch date and there is a possibility that we do not receive any data for consecutive 7 days.

       

      for Part 1 the launch was on 1/15 so the status will be New but after 7 days it should change to Old.

      Basically every week the business wants to look at new launches first and then old.

       

      Example 1

       

       

      Example 2

       

      For NZ part 1 was launched on 2/5 but there is no data on 2/7, 2/8, 2/9, 2/12. IT should not matter the status will change after 7 days of launch to Old on 2/13. Hope this helps.

      Part 2  -  Status will be new since it just got launched.

       

       

      Any suggestions will be very helpful.

       

      Thank you,

      Vandana