# Squarespace Orders

**URL:** <https://community.parabola.io/t/squarespace-orders/604>\
**Category:** Ask a question\
**Created:** [May 28, 2020, 6:44pm UTC](https://community.parabola.io/t/squarespace-orders/604 "2020-05-28T18:44:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Randall\_Hinton](https://avatars.discourse-cdn.com/v4/letter/r/82dd89/32.png) [@Randall\_Hinton](https://community.parabola.io/u/Randall_Hinton)\
**Post date:** [May 28, 2020, 6:44pm UTC](https://community.parabola.io/t/squarespace-orders/604/1 "2020-05-28T18:44:26Z")

</div>

I have been playing with your template recipe for manipulating SquareSpace Orders info. I have been able to get the Order information out of SquareSpace and done the basic manipulation. But I have been attempting to find a way to only grab the new orders, Orders since last import, or within the last 24 hours or something like that???

Thanks

---

<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:** [May 28, 2020, 7:43pm UTC](https://community.parabola.io/t/squarespace-orders/604/2 "2020-05-28T19:43:20Z")

</div>

Hey Randall! I can think of a couple different ways to accomplish this. How frequently do you want to run your flow? Do you envision setting it on a schedule to run once a day?

One way to accomplish this is to use our [Date Comparison](https://parabola.io/transforms/date-comparison) step. You can compare the Order Date against “Today” and then use a [Row Filter](https://parabola.io/transforms/row-filter) step to filter for the recent orders based on the new date difference column added by the Date Comparison step.

---

<div class="post-metadata">

**Author:** ![Kate\_Peer](https://avatars.discourse-cdn.com/v4/letter/k/ecccb3/32.png) [@Kate\_Peer](https://community.parabola.io/u/Kate_Peer)\
**Post date:** [July 17, 2020, 2:51pm UTC](https://community.parabola.io/t/squarespace-orders/604/3 "2020-07-17T14:51:00Z")

</div>

Hi Sachi. I’m working through what you are describing here, as I’m trying to accomplish the same thing as Randall (a spreadsheet that gets updated with new orders from SS, run at the end of every day).

I’ve got the Data Comparison step in there, but I’m getting an error about how one of my columns is in an incorrect format. And I’m not sure where ‘Today’ goes. Can you take a look?

 ![Screen Shot 2020-07-17 at 3.49.08 PM](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/669cb26d3a42fe1687d2b753db62c398a78a9708.png)

---

<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:** [July 17, 2020, 5:43pm UTC](https://community.parabola.io/t/squarespace-orders/604/4 "2020-07-17T17:43:07Z")

</div>

Hi @Kate_Peer - I see your `createdOn` column dates are formatted `DD-MM-YYYY`. I think this might be causing the problem when trying to compare against “Current Time” because it’s trying to compare dates that are formatted differently.

Can you try formatting your date to `YYYY-MM-DD`? The Date Comparison step should then add a “Date Comparison” column at the very right of your table.

Let me know how that goes! In general, I recommend saving any Date Formatter steps to the very end of the flow to ensure it doesn’t cause any issues with Date Comparisons or any other operations you might want to do with your date values.