1

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

0 Answers0