Supermetrics Support Forum

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


  • Hi Ellen,

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




    Best regards,

    Jouni Hyötylä

    supermetrics.com


    Twitter: @Supermetrics 

    Support forum: supermetrics/forum

  • Great, thanks!

  • 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

Login to post a comment