# App Sales: local Purchased Date instead

**URL:** <https://community.glideapps.com/t/app-sales-local-purchased-date-instead/2844>\
**Category:** Ask for Help\
**Created:** [December 12, 2019, 10:55pm UTC](https://community.glideapps.com/t/app-sales-local-purchased-date-instead/2844 "2019-12-12T22:55:11Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 17, 2019, 1:28am UTC](https://community.glideapps.com/t/app-sales-local-purchased-date-instead/2844/2 "2019-12-17T01:28:04Z")

</div>

Local time of the purchaser or the local time for you? Isn’t the timestamp technically stored as Zulu time and then the displayed time is determined from you systems local time zone? I always get confused on how Glide handles date/time, but what I explained above is my current interpretation.

In the glide created log sheets, I think Glide saves the dates as strings, so they need to be converted into proper dates. This thread has a formula that should convert it and the time should show for your local time if that’s what you are looking form. You’ll need to include HH:MM:SS if you want hour minute and second to show.

> [@Date formatting](https://community.glideapps.com/t/date-formatting/2612/2):
>
> I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT: =TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY")

---

_[View the full topic](https://community.glideapps.com/t/app-sales-local-purchased-date-instead/2844)._