Google Analytics Query Dynamic Dates

In Google Analytics, you have the option of pulling last 7 days, last 14 days, etc. nk the google analytics query node, that relative option doesn’t appear to exist. Additionally, it doesn’t appear that I can create a flow variable to dynamically pass through a from and to date based on upstream calculations to create that dynamic moving XX days window. How can I create a relative date range in the Google analytics query? Or do I have to go in daily and change the date range?

Looking at ga-dev-tools for GA4, you can overwrite the start end with “ndaysAgo” and “yesterday”, but in the connector, I can’t seem to create a text, only a calendar date select:

Please let me know if anyone has solved for this.