End

Applies to Movie and TV avails

EMA requirement: Required
Google requirement: Required

About this column

This column determines when a title will no longer be available for a specific combination of country, quality, and pricing in the "YYYY-MM-DD" or "ISO (8601)" Date+Time format. Recommended max end date is 2036-01-02. 

• If a title is intended to always be available, use "Open" as a placeholder value.
• Use "Immediate" to input the current date as the end date in our system.
• For pre-orders, use “ESTStart” as the end date to set a pre-order avail to end when the EST avail begins.
• For the date-only format (without time of the day) "YYYY-MM-DD", we will assume "00:00:00" in the first time zone in the corresponding territory.
• For date and time, use the "YYYY-MM-DDTHH:MM:SS" format. Applying a time zone can be done by adding an offset value after the timecode.
• Avoid using 9999-12-31 as this date falls outside of parsing range

Possible formatting options for adding an offsets are:

• "YYYY-MM-DDThh:mm:ssZ" - The value "Z" represents UTC
• "YYYY-MM-DDThh:mm:ss+hh:mm" - The value applied to "hh:mm" indicates the time offset from UTC for a particular place and date.

If the time zone is absent, the first time zone in the corresponding territory is assumed.

Best practices

A date value must be provided, even when updating non-date specific information.

Common mistakes

• Using an invalid value (Inf, TBD, TBC) or leaving it blank.
• Using a date format that is not "YYYY-MM-DD" or "YYYY-MM_DDTHH:MM:SS".
• Putting a start date after the end date.
• Using "YYYY-MM-DDTHH:MM:SS" without a "T" between the date and time.