Can I write an AWQL saying DURING 20140101, YESTERDAY?

[Laura Poole Harris]

I want my query to pull in all data starting from Jan 01, 2014 through yesterday. Is this possible?

[Umesh Dengale]

Hello,

The AWQL support custom dateRange with min and max in YYYYMMDD format for a DURING clause.  Either we have to use custom date range min and max in YYYYMMDD format(e.g. DURING 20140101, 20150720) or use a DateRange type (e.g DURING YESTERDAY or DURING LAST_MONTH). Above-mentioned date range 01/01/2014 through Yesterday, you need to specify the custom dateRange min and max date(e.g. DURING 20140101, 20150720) and DURING 20140101, YESTERDAY is not supported. 

Thanks,

Umesh, AdWords API Team.