# Pulling data from a several days ago each time

**URL:** https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465
**Category:** Ask a question
**Tags:** Building-Flows
**Created:** [January 15, 2021, 8:21pm UTC](https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465 "2021-01-15T20:21:15Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Akiko](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Akiko](https://community.parabola.io/u/Akiko)
#### Post date: [January 15, 2021, 8:21pm UTC](https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465/1 "2021-01-15T20:21:15Z")

</div>

Hi there,

Regarding the setting of “Pull from Shopify” step, I want to get data on cancellation orders where orders were processed **8 days ago** since our system automatically cancels the order if the customer doesn’t complete their payment in 8 days.

 ![Screen Shot 2021-01-15 at 2.50.06 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/0/012cac734ae3ea1ae83c4cc67b22e6253c68b7fd.png)

Right now, it’s possible to get data from 8 days ago like this, but it is for one-time use only.  
(so next day I will get January 8 data again)

I need to send this data to google sheet every day so is there any way to make this data setting change to January 9 automatically tomorrow?

Thanks,  
Akiko

---

<div class="post-metadata">

### Author: ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)
#### Post date: [January 15, 2021, 9:19pm UTC](https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465/2 "2021-01-15T21:19:22Z")

</div>

Hey Akiko 👋

Can you adjust your step settings to show orders that were processed `In the previous...`?

You should be able to set the value to `8 Days` and switch `from when the flow was run` to `from the most recently completed day`. Feel free to adjust this to `7 days` if you want to start on January 8th.

 ![previous_8](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/3/35e9143fee16756c16ea8032f65fb124690940fd.png)

This will dynamically pull in a list of orders from the previous 8 days each time your flow is scheduled to run. Let me know if that helps.

---

<div class="post-metadata">

### Author: ![Akiko](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Akiko](https://community.parabola.io/u/Akiko)
#### Post date: [January 16, 2021, 4:22pm UTC](https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465/3 "2021-01-16T16:22:16Z")

</div>

Thank you @daniel!  
but in this case, I will get data from Jan 8 -15, not only data from Jan 8.

I was expecting like…  
Get Jan 8 data \>\> run schedule on Jan 15  
Get Jan 9 data \>\> run schedule on Jan 16  
…

Is this setup possible?

---

<div class="post-metadata">

### Author: ![sachi](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/sachi/32/10_2.png) [@sachi](https://community.parabola.io/u/sachi)
#### Post date: [January 18, 2021, 6:37pm UTC](https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465/4 "2021-01-18T18:37:56Z")

</div>

Hey @Akiko - Following up for Daniel here. Thanks for clarifying. Your desired date filtering can totally be accomplished, we’ll just need a couple additional steps.

First, start with the date filtering that Daniel suggests in the `Pull from Shopify` step.

Then, connect a `Compare dates` step to compare the date column from Shopify with `current time`.

 ![Screen Shot 2021-01-18 at 10.34.28 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/1d481b9b327230652eb3145c790aaa50eac24656.png)

Lastly, to filter for the exact date, connect a `Filter rows` step and set up your filtering like this. Make sure to connect the two rules using an `AND` condition.

 ![Screen Shot 2021-01-18 at 10.35.33 AM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/7/7d0d3693171230574331e7d33af2be8fbacf59f6.png)

Please note that “Difference” is the name of my sample date column. Your column name from Shopify will be different.

This should do the trick! Let me know how it goes 🙂

---

<div class="post-metadata">

### Author: ![Akiko](https://avatars.discourse-cdn.com/v4/letter/a/ce73a5/32.png) [@Akiko](https://community.parabola.io/u/Akiko)
#### Post date: [January 18, 2021, 7:26pm UTC](https://community.parabola.io/t/pulling-data-from-a-several-days-ago-each-time/1465/5 "2021-01-18T19:26:19Z")

</div>

Amazing!! It worked and now I can get the data with 8 days delay.

Thank you @sachi 😉

Akiko
