# Set normal timestamp

**URL:** <https://community.glideapps.com/t/set-normal-timestamp/49338>\
**Category:** Ask for Help\
**Created:** [September 15, 2022, 12:55am UTC](https://community.glideapps.com/t/set-normal-timestamp/49338 "2022-09-15T00:55:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![hango1311](https://avatars.discourse-cdn.com/v4/letter/h/f4b2a3/32.png) [@hango1311](https://community.glideapps.com/u/hango1311)\
**Post date:** [September 15, 2022, 12:55am UTC](https://community.glideapps.com/t/set-normal-timestamp/49338/1 "2022-09-15T00:55:36Z")

</div>

i set the timestamp only short form.  
But when i use lookup or single date  
it was not a normal form (i need the day only)  
it have another number go along with  
How i can fix it??  
waiting for your help!!!

 ![スクリーンショット (263)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96f09bbbe51f96241db5f291c82cedbeca28cb22.jpeg)

---

<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:** [September 15, 2022, 1:13am UTC](https://community.glideapps.com/t/set-normal-timestamp/49338/2 "2022-09-15T01:13:04Z")

</div>

> [@hango1311](#):
>
> i set the timestamp only short form.

Where did you set that?

Can you show a screen shot please of the configuration of the associated column in the Glide Data Editor?

It should look something like this:

 ![Screen Shot 2022-09-15 at 9.12.34 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/c/3cc727b2f167dba9cd297e26a249a158f4fba28a.png)

---

<div class="post-metadata">

**Author:** ![hango1311](https://avatars.discourse-cdn.com/v4/letter/h/f4b2a3/32.png) [@hango1311](https://community.glideapps.com/u/hango1311)\
**Post date:** [September 15, 2022, 2:09am UTC](https://community.glideapps.com/t/set-normal-timestamp/49338/3 "2022-09-15T02:09:16Z")

</div>

firstly  
users will write down time

 ![スクリーンショット (264)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/d/2d2a001581c4472f3affabc8aad482f7bf0cc389.jpeg)  
 ![スクリーンショット (265)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f5dedefbc507ba96b576ae5a989223c566ef73b.jpeg)  
on Users data  
after that, i wanna take latest date  
so i use single value type for taking latest date on Users data

---

<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:** [September 15, 2022, 2:26am UTC](https://community.glideapps.com/t/set-normal-timestamp/49338/4 "2022-09-15T02:26:15Z")

</div>

In your first screen shot you show a Lookup column and a Single Value column.  
How is the Lookup column configured, and how is the Single Value column configured?  
Are they related?

Anyway… you can try this:

- After your Single Value column, add a Math column
- Just enter a single value as the formula, something like D
- Then use your Single Value column as a replacement for D
- And set the display format as you need it to be

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 19, 2022, 2:53am UTC](https://community.glideapps.com/t/set-normal-timestamp/49338/5 "2022-09-19T02:53:02Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.