Start a new topic

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 or Signup to post a comment