Supported date and time formats for dynamic creatives

To include date or time content in your dynamic creative feed (for example, to set start and end dates for feed content), use one of these formats:

Format Example
yyyyMMdd 20111230
MM/dd/yyyy 12/30/2011
yyyy/MM/dd 2011/12/30
MM-dd-yyyy 12-30-2011
yyyy-MM-dd 2011-12-30
MM/dd/yyyy H:m 12/30/2011 19:39
yyyy/MM/dd H:m 2011/12/30 19:39
MM-dd-yyyy H:m 12-30-2011 19:39
yyyy-MM-dd H:m 2011-12-30 19:39
MM/dd/yyyy'T'H:m 12/30/2011T19:39
yyyy/MM/dd'T'H:m 2011/12/30T19:39
MM-dd-yyyy'T'H:m 12-30-2011T19:39
yyyy-MM-dd'T'H:m 2011-12-30T19:39
MM/dd/yyyy H:m ZZ 12/30/2011 19:39 -08:00
yyyy/MM/dd H:m ZZ 2011/12/30 19:39 -08:00
MM-dd-yyyy H:m ZZ 12-30-2011 19:39 -08:00
yyyy-MM-dd H:m ZZ 2011-12-30 19:39 -08:00
MM/dd/yyyy H:mZZ 12/30/2011 19:39-08:00
yyyy/MM/dd H:mZZ 2011/12/30 19:39-08:00
MM-dd-yyyy H:mZZ 12-30-2011 19:39-08:00
yyyy-MM-dd H:mZZ 2011-12-30 19:39-08:00
MM/dd/yyyy'T'H:mZZ 12/30/2011T19:39-08:00
yyyy/MM/dd'T'H:mZZ 2011/12/30T19:39-08:00
MM-dd-yyyy'T'H:mZZ 12-30-2011T19:39-08:00
yyyy-MM-dd'T'H:mZZ 2011-12-30T19:39-08:00
MM/dd/yyyy H:m (ZZ) 12/30/2011 19:39 (-08:00)
yyyy/MM/dd H:m (ZZ) 2011/12/30 19:39 (-08:00)
MM-dd-yyyy H:m (ZZ) 12-30-2011 19:39 (-08:00)
yyyy-MM-dd H:m (ZZ) 2011-12-30 19:39 (-08:00)
MM/dd/yyyy H:m:s 12/30/2011 19:39:45
yyyy/MM/dd H:m:s 2011/12/30 19:39:45
MM-dd-yyyy H:m:s 12-30-2011 19:39:45
yyyy-MM-dd H:m:s 2011-12-30 19:39:45
MM/dd/yyyy'T'H:m:s 12/30/2011T19:39:45
yyyy/MM/dd'T'H:m:s 2011/12/30T19:39:45
MM-dd-yyyy'T'H:m:s 12-30-2011T19:39:45
yyyy-MM-dd'T'H:m:s 2011-12-30T19:39:45
MM/dd/yyyy H:m:s ZZ 12/30/2011 19:39:45 -08:00
yyyy/MM/dd H:m:s ZZ 2011/12/30 19:39:45 -08:00
MM-dd-yyyy H:m:s ZZ 12-30-2011 19:39:45 -08:00
yyyy-MM-dd H:m:s ZZ 2011-12-30 19:39:45 -08:00
MM/dd/yyyy H:m:sZZ 12/30/2011 19:39:45-08:00
yyyy/MM/dd H:m:sZZ 2011/12/30 19:39:45-08:00
MM-dd-yyyy H:m:sZZ 12-30-2011 19:39:45-08:00
yyyy-MM-dd H:m:sZZ 2011-12-30 19:39:45-08:00
MM/dd/yyyy'T'H:m:sZZ 12/30/2011T19:39:45-08:00
yyyy/MM/dd'T'H:m:sZZ 2011/12/30T19:39:45-08:00
MM-dd-yyyy'T'H:m:sZZ 12-30-2011T19:39:45-08:00
yyyy-MM-dd'T'H:m:sZZ 2011-12-30T19:39:45-08:00
MM/dd/yyyy H:m:s (ZZ) 12/30/2011 19:39:45 (-08:00)
yyyy/MM/dd H:m:s (ZZ) 2011/12/30 19:39:45 (-08:00)
MM-dd-yyyy H:m:s (ZZ) 12-30-2011 19:39:45 (-08:00)
yyyy-MM-dd H:m:s (ZZ) 2011-12-30 19:39:45 (-08:00)

 

Time data may be specified in hours and minutes in 24-hour time; seconds are optional. If no time is specified in your feed, then the time is assumed to be 00:00:00. For example, an element value with a 03/15/2013 start date and a 03/16/2013 end date serves for exactly 24 hours (midnight to midnight).

Types of start and end date scheduling

Date and time content can be targeted based on system time or user time. System time uses global UTC time (Coordinated Universal Time). When you upload your feed to Studio, it automatically converts the time into global UTC time for serving. If you do not include a specific time zone with your data in the feed, then it is assumed to be Pacific Time (PST/PDT, Google Mountain View time).

User time allows scheduled rules dynamic content swaps to be based on the time of the user. User time is determined by the IP address of the user. For instance, if the feed contained a column that was eligible from 12/12/2013 12:00:00 to 12/12/2013 14:00:00, that content would be eligible to be served from noon until 2PM for the user. When using user time, time zones should not be included and will result in errors during feed transformation. See Start and end date scheduling for additional information on how to set up a profile for user time.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
16706953220029250140
true
Search Help Center
true
true
true
true
true
74220
false
false