# How can I extract date from text column?

**URL:** https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008
**Category:** Ask for Help
**Created:** [May 22, 2023, 1:21pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008 "2023-05-22T13:21:08Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [May 22, 2023, 1:21pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008/1 "2023-05-22T13:21:09Z")

</div>

I have a text column with cells of data that are formatted with a combination of text and a date, e.g. Scheduled: 2023-06-12

I would like to extract the date part then perform some simple date maths. I have used a template column to delete the text part, leaving the date 2023-06-12. However, Glide does not treat that Template column as a date. Hence, I cannot add an if-then-else column with formula

If Template ‘is after Now’ then… since the date/time options for if-then-else do not appear.

I have successfully added a ‘Relative time’ column to identify ‘days ago/until’… so Glide can work with the template column. But not with the If-then-else format.

Any tips please?

Regards,  
Simon.

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [May 22, 2023, 1:41pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008/2 "2023-05-22T13:41:50Z")

</div>

Would it help if you converted the date to a number first and did your calculations on that number instead?

E.g year(date)\*10000+month(date)\*100+day(date)

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [May 22, 2023, 1:44pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008/3 "2023-05-22T13:44:14Z")

</div>

It’s a workaround, but I would love to have Glide simply accept that it is a date column and allow the date logic to be used.

---

<div class="post-metadata">

### Author: ![Joe\_Gabriele](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joe_gabriele/32/57595_2.png) [@Joe\_Gabriele](https://community.glideapps.com/u/Joe_Gabriele)
#### Post date: [May 22, 2023, 3:39pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008/4 "2023-05-22T15:39:42Z")

</div>

Have you tried using the Text to Date computed Column?

---

<div class="post-metadata">

### Author: ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [May 22, 2023, 4:23pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008/5 "2023-05-22T16:23:27Z")

</div>

Kisses.

---

<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: [May 23, 2023, 4:24pm UTC](https://community.glideapps.com/t/how-can-i-extract-date-from-text-column/62008/6 "2023-05-23T16:24:12Z")

</div>

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