Use Case: I have a collection with consulant with a field birhdate.
Now I want to create a flow to read all consultant who have birthday this month.
{
"collection": "Consultant",
"query": {
"filter": {
"month(birthdate)": {
"_eq": "month($now)"
}
}
}
}
Does not work!!!
When I hardcode the month it works nicely
{
"collection": "Consultant",
"query": {
"filter": {
"month(birthdate)": {
"_eq": "7"
}
}
}
}
Any suggenstions?
extract current month out of $now in a filter