Split and add date

Ask for Help
1

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

2

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)

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.

4

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)

2 Likes