I implemented a simple function that calculates the difference between a date and the function TODAY().
The automation should trigger everytime this calculation is updated, hence everyday, although it does not.
It would be nice if automations could be compatible with certain functions to allow more flexibility on trigger conditions.