I want to create a birthday list based on the data stored in the user profiles. I have a text field "birthday" which is populated with dates in the form yyyy-mm-dd. I want to display birthday lists for:
- the current day
- the current month
- all users
Which queries can I use for this purpose?
Solution
...
Code Block | ||
---|---|---|
| ||
birthday: *-11-* |
Code Block | ||
---|---|---|
| ||
(1*) OR (2*) |
...
...
...
...
...
...
...