I think dynamic variables like $NOW are not interpreted inside the json query of a flow.
But you can definitely calculate the current date in the previous operation and then use the passed value afterwards.
I’m describing a similar case passing the weekday to the next operation. You would want to pass the complete date instead of course.