Grab Date From Title

Grab Date From Title

Master Tag
Tips & Tricks
Created
Apr 24, 2022 02:00 AM
How It Works
Usage
dateAdd
dateSubtract
Year
Hour
minute
Month
Slice
Web Tags
Formula
Database
Alternatives
Cover

Donate

⚠️
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.
 
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")