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

[nshindel]

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.

[jeffshieldsdev]

Use Date.StartOfMonth and Date.AddMonths

Date.AddMonths(Date.StartOfMonth(Date.From(DateTime.LocalNow())), -13)

[PedroReis]

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]

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.