1 Reply Latest reply on Sep 21, 2018 4:15 PM by Motorola Licenses

    Tableau Rolling Dates

    Motorola Licenses

      I have a requirement wherein i have a start date and an end date and a frequency for system check.

       

      Want to find out how many system checks are pending before the end the date and when is the next system check date after TODAY().

       

             

      Start DateFrequency1st date2nd date3rd date4567 end date
      1/1/201626weeks6/29/201612/26/201612/26/20166/24/20176/24/201712/21/201712/21/2017 12/31/2020
      6/3/201652 weeks6/3/20176/3/20186/3/20186/3/20196/3/20196/2/20206/2/2020 1/1/2021