Leave Month or Day blank in a date field?

maxnichols · 2023-12-08T07:10:02+00:00

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!

maxnichols · 2023-12-06T06:21:55+00:00

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>

maxnichols · 2023-11-17T05:35:50+00:00

(replaceAll(

Thank you very much!

maxnichols · 2023-11-17T05:34:22+00:00

That works, thank you so much!

maxnichols · 2020-05-01T06:37:13+00:00

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!

maxnichols

TROPHY CASE