A formatted date in the date formula property (notion.so)

Apr 23, 2023#utility160

AI-generated summary

To convert a date from DAY, MONTH, and YEAR numbers, use the formula dateAdd(dateAdd(dateAdd(fromTimestamp(0), DAY - 2, "days"), MONTH - 1, "months"), YEAR - 1970, "years"). This formula adds the days, months, and years to January 1, 1970, which is obtained from fromTimestamp(0). A user encountered a "Type mismatch" error while creating a date formula in Notion, but found a solution on Reddit.

If you have DAY, MONTH and YEAR as numbers for a date, you can convert that to a date by using the following formula:

dateAdd(dateAdd(dateAdd(fromTimestamp(0), DAY - 2, "days"), MONTH - 1, "months"), YEAR - 1970, "years")

This uses the fact that fromTimestamp(0) gives you the date for January 1, 1970, and then adds the days, months and years to get to the target date.
source

I attempted to create a property with a date formula to monitor dates in Notion. As I adjusted the date formats, the message "Type mismatch: ****** is not a date" continued popping up. It appears to be better now that I found one solution on Reddit.

Notes: I altered the original version to "DAY – 2" to ensure that it worked well in another formula.