# Been asked before, but... How do I add a day to a date column?

**URL:** https://community.glideapps.com/t/been-asked-before-but-how-do-i-add-a-day-to-a-date-column/74977
**Category:** Ask for Help
**Created:** [July 17, 2024, 8:09pm UTC](https://community.glideapps.com/t/been-asked-before-but-how-do-i-add-a-day-to-a-date-column/74977 "2024-07-17T20:09:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Jason\_Bronfeld](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_bronfeld/32/64705_2.png) [@Jason\_Bronfeld](https://community.glideapps.com/u/Jason_Bronfeld)
#### Post date: [July 17, 2024, 8:09pm UTC](https://community.glideapps.com/t/been-asked-before-but-how-do-i-add-a-day-to-a-date-column/74977/1 "2024-07-17T20:09:58Z")

</div>

I’ve seen this asked before and the answer has been " In a math column, type `date + 1` and replace `date` with the date column." In the resulting math column, I get a number, not a date. What gives?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f777512a4004000b316ca9630fc077938c854f46.png)

---

<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: [July 17, 2024, 8:33pm UTC](https://community.glideapps.com/t/been-asked-before-but-how-do-i-add-a-day-to-a-date-column/74977/2 "2024-07-17T20:33:39Z")

</div>

Your date column is not a true Date type column. The math column is just reading the numbers from your date column as a numeric value, and not a date value.

What type of column is your date column and how is it populated?

---

<div class="post-metadata">

### Author: ![Jason\_Bronfeld](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_bronfeld/32/64705_2.png) [@Jason\_Bronfeld](https://community.glideapps.com/u/Jason_Bronfeld)
#### Post date: [July 17, 2024, 8:41pm UTC](https://community.glideapps.com/t/been-asked-before-but-how-do-i-add-a-day-to-a-date-column/74977/3 "2024-07-17T20:41:16Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c55614b9909895af3e7459d2b6c17c0a369d5bb.png)

Thank you. When I switch to the underlying date column, the problem goes away. I’ll add an enhancement request to fix this since the format-date type is implicitly a date.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/4/64f7b1effa891b67629e81eb2d7e3cd65361e365.png)

---

<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: [July 17, 2024, 8:50pm UTC](https://community.glideapps.com/t/been-asked-before-but-how-do-i-add-a-day-to-a-date-column/74977/4 "2024-07-17T20:50:23Z")

</div>

It’s not technically broken. Format Date returns text. Not a date. If you need the date in a mm/dd/yyyy format, I recommend using a math column that refers to your original date column and set the formatting there to short date. That way it will still be recognized as a true date.