Help between Notion users

It's free & easy

Receive points, vote and give the solution

1vote

# Updated formula to get date from title.

Hi,

this formula i found is no longer working I think since Notion did some updates on their formula language

``dateAdd(dateAdd(dateAdd(dateSubtract(dateSubtract(dateSubtract(dateSubtract(dateSubtract(now(), year(now()), "years"), month(now()), "months"), date(now()) - 1, "days"), hour(now()), "hours"), minute(now()), "minutes"), toNumber(slice(prop("Name"), 6, 10)), "years"), toNumber(slice(prop("Name"), 0, 2)) - 1, "months"), toNumber(slice(prop("Name"), 3, 5)) - 1, "days")``

Error:"Argument of type text does not satisfy function slice."

Would anybody be so kind to help me with this? Replacing slice with substring does not work either, equals empty value

0vote

### polle commented 6 days ago

Please share exactly how are you writing it.

1vote

### Didi commented 4 days ago

a date on the page's title, for instance 05-05-2022, on that format.
Thanks for answeing, I'd really appreciate it if you could help me

0vote

polle Points68560

I believe this is the Notion formula you are looking for.

``dateAdd(dateAdd(dateAdd(dateSubtract(dateSubtract(dateSubtract(dateSubtract(dateSubtract(now(), year(now()), "years"), month(now()) - 1, "months"), date(now()) - 1, "days"), hour(now()), "hours"), minute(now()), "minutes"), toNumber(substring(prop("Name"), 6, 10)), "years"), toNumber(substring(prop("Name"), 0, 2)) - 1, "months"), toNumber(substring(prop("Name"), 3, 5)) - 1, "days")``

Hope that helps.

0vote

### Didi commented 3 days ago

It worked, It really helps a lot. Thank you very much Polle

0vote

...