Hi Brendan,
I want to create a database of birthdays of my family. On these days I would like to make the following query, “today’s and next birthdays”. Can you explain me me how to do this, I can not find the calculation functions to do this by myself.
Thank you in advance.
Juriaan Bakker
Hi Juriaan,
You can do a query for any record where a specific date field is today. To do that, click on your form, then click on the gear button. Then select the date you want and then click on your Date field. From the comparisons popup button, select “is today”.
But there’s nothing specific to filter records for the “next birthday”.
Brendan,
Thanks for your explanation.
Juriaan
I don’t think the today or any dates queries find based on the month and day as
04/25
In order to find birthdays.
I would suspect there’s a way to write an Js to pull out the day and month
Never mind I found this
DATE(Date Field, “MM/dd”)
Must use this in order to search
DATE(Date Field, “MMdd”)
I.e.
0425
0914
Wrap the search term in quotes and it might find it with the slash in it.
I commonly have a section heading for small fields like this at the bottom of the record, either called “Calcs”, “Join Fields” or “Linking Metadata” that I hide these calculation or script fields in. This helps me split out these sorts of fields that I use for search purposes (like combining shipping tracking numbers together or computing alternate order ID’s) and then collapse the section to hide them. You can also hide the collapsed section heading field to make it all disappear entirely without having to toggle the hidden state on each field. For me collapsing the section heading is enough but depending on your environment you might be interested in hiding it as well.
.
