# Only takes the date

**URL:** <https://community.glideapps.com/t/only-takes-the-date/60554>\
**Category:** Ask for Help\
**Created:** [April 14, 2023, 11:11pm UTC](https://community.glideapps.com/t/only-takes-the-date/60554 "2023-04-14T23:11:57Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [April 14, 2023, 11:11pm UTC](https://community.glideapps.com/t/only-takes-the-date/60554/1 "2023-04-14T23:11:57Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/40f93d8b170cf2c2b2a51aff80894ddb1623e666.png)  
Hi…  
How do I retrieve just the date, I’m sure I’ve seen a similar issue, but I can’t find it.  
example 15 jan 2023, I only want to take the date “15”

Thank You

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 14, 2023, 11:26pm UTC](https://community.glideapps.com/t/only-takes-the-date/60554/2 "2023-04-14T23:26:30Z")

</div>

Use a Math column:

DAY(T) with T being the “Date Time” column you show in the screenshot.

---

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [April 15, 2023, 3:56pm UTC](https://community.glideapps.com/t/only-takes-the-date/60554/3 "2023-04-15T15:56:01Z")

</div>

Thank You @ThinhDinh  
it worked…

---

<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:** [April 16, 2023, 3:56pm UTC](https://community.glideapps.com/t/only-takes-the-date/60554/4 "2023-04-16T15:56:34Z")

</div>

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