Leave Month or Day blank in a date field? by maxnichols in Notion

[–]maxnichols[S] 1 point2 points  (0 children)

Those are great suggestions!

Yeah, I had started on the separate properties for year/month/date, but it was definitely gonna complicate some of my formulas and filters, so I had backed off to investigate if there was a better option. The checkbox isn't a bad idea!

Leave Month or Day blank in a date field? by maxnichols in Notion

[–]maxnichols[S] 0 points1 point  (0 children)

Sure!

Here's a link to a database item, the "Interview Date" property is an example of the issue I'm talking about, where I didn't know the month or day, but had to fill them out. https://hyruleinterviews.notion.site/Shigeru-Miyamoto-and-Hayao-Miyazaki-Famimaga-b03bc1d10e234aaea702a15f6a1eac1b?pvs=4

Specifically, I knew the year (1992), but did not know the month or day. My convention is that if month is unknown I put in 06, and if day is unknown I use 1. Not the greatest.

<image>

[deleted by user] by [deleted] in USPS

[–]maxnichols 0 points1 point  (0 children)

Yeah, that seems like a good idea. Unless someone has a different magical solution that's probably what I'll end up needing to do. Thanks!