 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

### polle commented 6 days ago

Please share exactly how are you writing it.

### 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

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.

### Didi commented 3 days ago

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