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!
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