# Detect Date in Column to enable Date Time Picker

**URL:** https://community.glideapps.com/t/detect-date-in-column-to-enable-date-time-picker/5909
**Category:** Ask for Help
**Created:** [March 26, 2020, 6:08pm UTC](https://community.glideapps.com/t/detect-date-in-column-to-enable-date-time-picker/5909 "2020-03-26T18:08:27Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![brandonley](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@brandonley](https://community.glideapps.com/u/brandonley)
#### Post date: [March 26, 2020, 6:08pm UTC](https://community.glideapps.com/t/detect-date-in-column-to-enable-date-time-picker/5909/1 "2020-03-26T18:08:27Z")

</div>

I have a spreadsheet with a column called Date. The user is supposed to be able to edit and enter new dates. The sheet already includes dates such as: 2/2/2019 13:00:00. Yet, the app does not recognize this field as Date Time. I don’t want users to enter dates annually as they will each come up with diffetrent formats.

So, how do I enable the date time picker for this date fields in my app?

---

<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: [March 26, 2020, 6:36pm UTC](https://community.glideapps.com/t/detect-date-in-column-to-enable-date-time-picker/5909/2 "2020-03-26T18:36:32Z")

</div>

What happens when you add the date time picker and point it to that column?

---

<div class="post-metadata">

### Author: ![brandonley](https://avatars.discourse-cdn.com/v4/letter/b/b77776/32.png) [@brandonley](https://community.glideapps.com/u/brandonley)
#### Post date: [March 26, 2020, 7:13pm UTC](https://community.glideapps.com/t/detect-date-in-column-to-enable-date-time-picker/5909/3 "2020-03-26T19:13:10Z")

</div>

Ah great. Not sure how I missed that. That was it.