Removing Year from {{NOW}} with date formatter

Need to filter a table with DOB’s in them for example: 1971-03-30
However I want to add the following into the query:
dob between. {{NOW.formatDate(“MM-dd”)}}. AND {{NOW.formatDate(“MM-dd”).dateAdd(“days”, 20)}}

So this way I can list birthdays coming up in the next 20 days.

How on earth can I get this to work??
Have spent hours on this now, trying to get it to work and it just won’t.

The problem is unless I can format the date I cannot filter it on day and month for use with an upcoming birthdays part and the {{NOW}} will always give the current year and 1971 is WAY more than 20 days to go.

Pretty frustrated by this now and hoping someone can help.

Community Page
Last updated: