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:
Last updated: