I use a dataview query in my dialy note where I show all the people that have there birthday in the coming week. The query I use is the following.
list birthday from #person where birthday.month = this.file.day.month and (birthday.day >= this.file.day.day and birthday.day <= this.file.day.day + 7) sort birthday.day
This works very nice. The only thing is that by showing the birthday the date of birth is shown including the day. Which is correct for the year the person was born in but most of the times not for the current year.
So I would like to remove the day element from the date presentation and maybe the year also so you only keep day-month presentation.
Can this be done?
- remove the year and day element of a date OR
- concatenate the birthday.day with a ‘-’ and birthday.month?
Any help is appreciated.