get all experiment whose end_date is greater than today in v12

19 views
Skip to first unread message

Mahendra Garg

unread,
Jan 16, 2023, 10:32:57 AM1/16/23
to Google Ads API and AdWords API Forum
Hi guys

I'm facing an issue to query to get experiments. I want experiment whose end date is greater than today.
```
SELECT experiment_arm.campaigns,
                    experiment_arm.experiment,
                    experiment.end_date,
                    experiment.resource_name
                FROM experiment_arm
                WHERE experiment.status IN ('ENABLED')
                AND experiment.end_date > '{today}' 
```
but in v12 `>` is not available, only available operators are `Valid operators: =, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, REGEXP_MATCH, NOT REGEXP_MATCH.`

please let me know if anyone have gone through by it.

Thanks
Reply all
Reply to author
Forward
0 new messages