Proper way to write a subquery on GQL

[Ícaro Lorran]

I want to make this query:

```

SELECT

customer.currency_code,

customer.id,

campaign.name,

campaign_budget.amount_micros,

metrics.cost_micros,

segments.date

FROM campaign

WHERE

segments.date BETWEEN campaign.start_date AND campaign.end_date

```

But since the clause `BETWEEN` expects a string in the format `YYYY-MM-DD`, it yields an error related to it. What is the proper way to write the WHERE clause?

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

With regards to your concern, since the campaign.start_date and campaign.end_date are in the YYYY-MM-DD format, it is expected that when you want to put these in the WHERE clause, you will also need to put their values in the YYYY-MM-DD format.

In addition, to have a clearer understanding regarding this, I would really suggest using these query builder and query validator tools that will help and guide you as you build and validate your query.

Let us know if you have further questions.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2hyBqZ:ref