Forum Discussion

nshindel's avatar
nshindel
Frequent Visitor
7 years ago

Advanced Editor - Date Editor - From today, look 13 full months back

Hi - I am using M in the advanced editor to try and make a dynamic date range. Ideally, I would like to go back 13 months from today's date, but just at the month level.

 

For example, today is May 28th, 2019, I want the date range to be April 1, 2018 - May 28 2019, and on June 1st, the date would change to May 1 2018 - June 1 2019, etc, etc. I cannot figure out the syntax.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Which data source are you using? Don't you have a Date Dimension? Then it's very simple with SQL.


    Select * from DIM_DATE

    WHERE date >= select dateadd(mm, datediff(mm, 0, @ThisDate) - 13, 0)  -- Beginning of 13 months ago

    • nshindel's avatar
      nshindel
      Frequent Visitor
      7 years ago

      Hi - This is not in SQL. I am actually connecting through the Adobe Analytics API, so it has to be done in the Advanced Editor.