option to ignore the year in dates (stripyear)

[filmgal]

I would love an option to ignore the year, a "stripyear" if you will, much like the existing "striptime".
It would make it so much simpler to write tables for things like due today, or upcoming.

• we could easily include birthdays, where we never want the year
• we could include annual magazine or software subscription renewals, because there, too, the year doesn't matter
• we could include monthly bill payments
• we could even include weekly things like stuff that happens every Thursday

We can include these things now with a bit of creativity and help from the lovely folks on Discord, but something like this:

where birthday.month = date(today).month and birthday.day = date(today).day
could turn into something like this:

where stripyear(birthday) = stripyear(date (today)).

Heck, while I'm at it, a combo stripyear-stripmonth would be good too!

[blacksmithgu]

There isn't really a way to strip a year from a luxon DateTime (they are always defined by year-month-day), but there are a few somewhat clean options. If you just want month-day, you can do

WHERE dateformat(birthday, "mm-dd") = dateformat(date(today), "mm-dd")

And for just days you can just compare the date(today).day field.

[filmgal]

Well that is just friggin' brilliant! Except, the results aren't quite the same. Odd things going on ;-)
My original code:

table due as "Today"
where startswith(file.path, "Calendar/Weekly/" + dateformat(date(today), "cccc")) 
or startswith(file.path, "Calendar/Monthly/" + dateformat(date(today), "dd"))
or startswith(file.path, "Calendar/Yearly/" + dateformat(date(today), "MM-dd"))
or (birthday.month = date(today).month and birthday.day = date(today).day)
or striptime(due) = date(today) 
sort file.name

The same code but with the birthday line you suggest:

table due as "Today"
where startswith(file.path, "Calendar/Weekly/" + dateformat(date(today), "cccc")) 
or startswith(file.path, "Calendar/Monthly/" + dateformat(date(today), "dd"))
or startswith(file.path, "Calendar/Yearly/" + dateformat(date(today), "MM-dd"))
or dateformat(birthday, "mm-dd") = dateformat(date(today), "mm-dd")
or striptime(due) = date(today) 
sort file.name

oops. Sorry. I meant to black out that first entry. It was the only legit thing I had on my calendar for today!

[filmgal]

if it helps to troubleshoot, that last entry in your method has a birthday of 1994-08-10
So it looks like it's really picking up the 10s.

[filmgal]

more info: If you use capital MM-dd in your formula, it works in the sense that it only picks up the correct "Birthday test due Nov 10.
On the other hand, that is the only entry, so it is ignoring everything else.

[blacksmithgu]

This is actually related to another bug you filed with OR not working properly - the gist of it is that OR is actually working fine, but Dataview automatically throws out results that fail to evaluate due to an error. If birthday is not defined on a page, then dateformat(birthday, ...) errors and the row is thrown out.

This is being fixed in upcoming bugfix release 0.4.21 (and hopefully those fixes will fix your other open issue).

[blacksmithgu]

Also, I think it should be "MM-dd", not "mm-dd" - my bad!

[filmgal]

In case anyone else is interested, this works perfectly now. The following is for anything due today, whether it is

• a birthday (ignores the birth year, so birthday: 1982-12-07 shows up), or
• weekly files that begin with today's day of week, e.g., Tuesday recycling or
• monthly files that begin with today's date, e.g., 07 - pay bills or
• yearly files that begin with today's month-date, e.g., 12-07 renew Adobe subscription or
• files that have a due date of today, e.g., due:: 2021-12-07.

```dataview
table due as "today"
where startswith(file.path, "Calendar/Weekly/" + dateformat(date(now), "ccc"))
or startswith(file.path, "Calendar/Monthly/" + dateformat(date(now), "dd"))
or startswith(file.path, "Calendar/Yearly/" + dateformat(date(now), "MM-dd"))
or striptime(due) = striptime(date(now))
or (birthday.month = date(now).month and birthday.day = date(now).day)

Tip: to make it work for "Tomorrow", just replace all instances of date(now) with date(tomorrow).