1 Reply Latest reply on Nov 20, 2018 8:50 AM by Ritesh Bisht

    Need an help in date conditions

    sunil sudendran

      Hi team

       

      Please help me in creating a condition for

       

      last 30 days from today
      last month
      current month

        • 1. Re: Need an help in date conditions
          Ritesh Bisht

          CURRENT MONTH

          month([Order Date])= MONTH(TODAY())-1  and year(today())=year([Order Date])

           

           

          LAST MONTH

          month([Order Date])= MONTH(TODAY())-1  and year(today())=year([Order Date])

           

          last 30 days from today

          [Last 30 Days] = SUM(IF TODAY() - ATTR([YOUR DATE FIELD]) <= 30 THEN [SALES] ELSE 0 END)

           

          Please mark the answer if it helps you so that it can help others as well

           

          Thanks,

          Ritesh