GA "today" is 5 days ago?

I recently integrated Google Analytics into Metabase. I am trying to write some queries to combine our top of the funnel data from GA with our bottom of funnel data from our internal DB.

I have written a simply query to select users and a goal from GA for "today". The query is returning data from July 10. Today is July 15.

Is this a known issue? Is there another dynamic variable I could use? I don't really want to hardcode this and have to update the query all the time.

Screenshot:

Hi @jb_trustedchoice
Looks like you are grouping by week, which is why you got the data from start of week.