Donate

<aside> ⚠️ If you use a database for daily entries, like a journal, and populate each title with a date, this formula allows you to create a date from that title. For it to work properly, the date must have this format: MM-DD-YYYY or MM/DD/YYYY or MM DD YYYY.

</aside>

Grab Date In Title

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")