# Get Rows is pulling wrong the wrong date

**URL:** <https://community.glideapps.com/t/get-rows-is-pulling-wrong-the-wrong-date/73128>\
**Category:** Ask for Help\
**Created:** [May 6, 2024, 9:46pm UTC](https://community.glideapps.com/t/get-rows-is-pulling-wrong-the-wrong-date/73128 "2024-05-06T21:46:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcabs13](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jcabs13/32/56333_2.png) [@jcabs13](https://community.glideapps.com/u/jcabs13)\
**Post date:** [May 6, 2024, 9:46pm UTC](https://community.glideapps.com/t/get-rows-is-pulling-wrong-the-wrong-date/73128/1 "2024-05-06T21:46:30Z")

</div>

I have a date column that is only manipulated through a date picker (not a date/time picker) and the column is set to date only + short. Double clicking in the cells still shows a timestamp which I find odd but that’s not really the issue. The issue is that when I use the Get Row function from Make (Previously known as Integromat), I receive a date that is one day before what is actually marked in Glide. There are no intermediary steps here and I have double checked the row reference ID. All the other data for this row is being pulled properly so I think it has to be something with the date formatting of Glide’s API and timestamp. I have also tried with and without the “Respect time zones” checked and that doesn’t seem to be it either.

I have tried manipulating the data with a split array and single value columns to isolate just the date as text and this works in Glide, but since calculated columns are not received through a Get Row call, I’m at a loss for how to do this on the other side in Make. It’s also way messier than it should be. It should literally just be a date column with no timestamp. Any ideas?

 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c233a2e6a804f8debcdc298257f15a1f2f67e370.png)

 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9f68626a26954c5de769463a5b9d12c11e008f5.png)

 ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c02f8eea8ba77442eafbf5844fe480aa0f66996c.png)

 ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/acfe970e02050a3a4fad0b400746345da3730ae7.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [May 7, 2024, 3:54am UTC](https://community.glideapps.com/t/get-rows-is-pulling-wrong-the-wrong-date/73128/2 "2024-05-07T03:54:17Z")

</div>

My guess is that Make is applying a Timezone offset correction based on your Organisation Timezone settings. You can check that from your Org dashboard under Organisation Settings.

 ![CleanShot 2024-05-07 at 11.53.25@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b14810ce254e55d789b737174ca393033e33ed71.jpeg)