How to build a dynamic "Last 6 Months" date range component based on an existing Top right panel date? | Community
Skip to main content
H
HSN23
Level 1
July 2, 2026
Solved

How to build a dynamic "Last 6 Months" date range component based on an existing Top right panel date?

  • July 2, 2026
  • 3 replies
  • 87 views

I need to create a custom last 6 month date range component  that automatically calculates a "last 6 months" window relative to that panel's date. What is the best approach or logic to derive this 6-month lookback period dynamically?

Best answer by MandyGeorge

Yes, using the make date ranges relative to panel is the best option for what you want. A couple things to keep in mind, if you add a new panel, you will have to select that option for each panel. 

The other thing to note is that the date becomes relative to the first date in your panel range. For example, if you're using "last 7 days" in your table, and you set you calendar to June 1 to 30, your table will have May 25 to 31. In the same regard, a date range in your table like "last 6 full months" will be relative to the first date as well. So for June 1 to 30 it would give you all of Dec to May. If your panel date range spans more than one month, for example May 15 to June 15, then it would give you all of Dec to April.

So using a combination of rolling date ranges and this relative feature is likely what you want, just keep in mind how it works.

3 replies

bjoern__koth
Community Advisor and Adobe Champion
bjoern__kothCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 2, 2026

I don't think there is such thing as a dynamic date range component based on the selected date in your date picker 

Cheers from Switzerland!
A
AlexanderSo1
Level 2
July 3, 2026

Hi ​@HSN23, 

You can likely use the rolling date range options. You can create a new date range that starts 6 months ago:
 

 

The panel’s date range can be updated to be a rolling date range too. Below, I’ve chosen the rolling date range for the panel to be the current month minus 1 month:
 


This results in a custom date range that begins 6 months before (i.e. relative) the start of the panel’s date range:
 


These dates should roll (i.e. update dynamically) as time progresses given that they’re both rolling date ranges.

​​​​​​​Hope this helps.​​​​​​​

    H
    HSN23Author
    Level 1
    July 3, 2026

    Hi ​@bjoern__koth  ​@AlexanderSo1   thanks for your responses! I used the option below and it solved the problem. 

     

      MandyGeorge
      Community Advisor and Adobe Champion
      MandyGeorgeCommunity Advisor and Adobe ChampionAccepted solution
      Community Advisor and Adobe Champion
      July 4, 2026

      Yes, using the make date ranges relative to panel is the best option for what you want. A couple things to keep in mind, if you add a new panel, you will have to select that option for each panel. 

      The other thing to note is that the date becomes relative to the first date in your panel range. For example, if you're using "last 7 days" in your table, and you set you calendar to June 1 to 30, your table will have May 25 to 31. In the same regard, a date range in your table like "last 6 full months" will be relative to the first date as well. So for June 1 to 30 it would give you all of Dec to May. If your panel date range spans more than one month, for example May 15 to June 15, then it would give you all of Dec to April.

      So using a combination of rolling date ranges and this relative feature is likely what you want, just keep in mind how it works.

      Terms & ConditionsAccessibility statement

      Loading footer...