# Split and add date

**URL:** <https://community.glideapps.com/t/split-and-add-date/49473>\
**Category:** Ask for Help\
**Created:** [September 16, 2022, 6:18pm UTC](https://community.glideapps.com/t/split-and-add-date/49473 "2022-09-16T18:18:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Javier\_Flores](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/javier_flores/32/47927_2.png) [@Javier\_Flores](https://community.glideapps.com/u/Javier_Flores)\
**Post date:** [September 16, 2022, 6:18pm UTC](https://community.glideapps.com/t/split-and-add-date/49473/1 "2022-09-16T18:18:32Z")

</div>

Hi everyone!

Do I have any way to split the day, month and year from a date into a singles numbers? for example… 09/16/2022 ==\> 0+9=9 1+6=7 2+0+2+2=6

Thanks

JJ

---

<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:** [September 16, 2022, 7:08pm UTC](https://community.glideapps.com/t/split-and-add-date/49473/2 "2022-09-16T19:08:55Z")

</div>

You could do that with the math column.

i.e. year(date) where you replace the date with your date.  
month(date)  
weeknum(date)  
day(date)

> **[Math Column](https://www.glideapps.com/docs/reference/computed-columns/math-column)**
>
> Perform instant calculations using the data in your projet.

You could try something like this for the specific day.  
year(date)\*10000+month(date)\*100+day(date)

Put that into the configuration of a math column and replace date with your date.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [September 16, 2022, 8:42pm UTC](https://community.glideapps.com/t/split-and-add-date/49473/4 "2022-09-16T20:42:41Z")

</div>

Here’s what I would do:

1. Add a math column to grab the month(date)
2. Add a split text column. Use the template as a source. For the split by, delete the `, ` and this should split the template column into separate digits.
3. Add a rollup column. For the source, select the split text column and select “Sum”. This should add all the single digits together

Repeat for each part of the date:  
day(date)  
year(date)