Choosing a set start date but floating end date

I have several needs where I want the query to use a fixed start date, but i want it to keep updating the end date to yesterday. How can I do this?

So for example, I will pull all GA sessions from 1/19/17 - yesterday and have it refresh daily

1 person likes this idea
  • Hi Ellen,

    you can use written date commands in the fields. For the end date, write "yesterday".

    Best regards,

    Jouni Hyötylä

    Twitter: @Supermetrics 

    Support forum: supermetrics/forum

  • Great, thanks!

    1 person likes this
  • What if i want a specific start date till the end of last month?

    Can you do end of previous month?

  • You can also do it like this:

    Start date: first day of last month
    End date: last day of last month

    and many other combos like that.

    Best regards,

    -Supermetrics Team

  • I'm having the same issue. I'm not seeing where I can set the End Date for a date in the future or "last day of the month". I'm unable to click any dates in the future beyond today. Please advise.


Login to post a comment