Click or drag to resize

IMPORT CONSTRAINTS DateTimeType

Verizon Connect Logo
Print this page
Learn more about Verizon Connect GeoBase.
Get information about the latest release

This topic describes the DateTimeType.

DateTimeType

A DateTimeType is a string that is used to define the dates when a turn restriction applies.

Note Note
  • All date ranges are inclusive. The constraint applies on the start day and end day, and on all days in between.
  • If the start and end dates are the same, the constraint applies for that single day (or week or month).
  • Days of the week start on Sundays, with Sunday being day 1 and Saturday being day 7.

Description

Possible values for DateTimeType are listed in the left column. The date1 and date2 columns show the corresponding format for each DateTimeType.

Type String

Description

date1

date2

Example

DayMask

The restriction takes effect on one or more days every week.

If a day is marked as true (Y), then the restriction is in effect on that day of the week. If a day is marked as false (N), then the restriction is not in effect on that day.

Boolean mask

Week starts on Sunday

Format: XXXXXXX

Not used

date1: YYNYNNN

Restriction applies every Sunday, Monday, and Wednesday

DateRange

The restriction takes effect between two dates.

Start date

Format: yyyyMMdd

End date

Format: yyyyMMdd

date1: 20190430

date2: 20201107

Restriction applies between April 30, 2019 and November 7, 2020

DayOfMonth

The restriction takes effect between certain days of each month.

You cannot apply the attribute 'fromEnd' to this date type when using this date type in the 'DateSpec' of the IMPORT CONSTRAINTS statement.

Start day

Format: 00dd0000

End day

Format: 00dd0000

date1: 00070000

date2: 00220000

Restriction applies between the 7th and 22nd of every month

DayOfMonthOfYear

The restriction takes effect every year between certain days of the specified months.

Start day of month

Format: 00dd00MM

End day of month

Format: 00dd00MM

date1: 00250003

date2: 00100011

Restriction applies every year between March 25 and November 10

DayOfWeekOfMonth

The restriction takes effect every month between two days of each specified week. The week is identified by the week number per month. The days are 1-7 (Sun-Sat). Week 1 begins on the first Sunday of the month.

Start day of week

Format: 000d000w

End day of week

Format: 000d000w

date1: 00030001

date2: 00010003

Restriction applies between Tuesday of the 1st week and Sunday of the 3rd week of every month.

DayOfWeekOfYear

The restriction takes effect every year between two days of each specified week. The week is identified by the week number per year. The days are 1-7 (Sun-Sat). Week 1 begins on the first Sunday of the year.

You cannot apply the attribute 'fromEnd' to this date type when using this date type in the 'DateSpec' of the IMPORT CONSTRAINTS statement.

Start day of week

Format: 000d00ww

End day of week

Format: 000d00ww

date1: 00070008

date2: 00050024

Restriction applies between Saturday of the 8th week and Thursday of the 24th week of every year.

MonthOfYear

The restriction takes effect between two months of every year.

Start month

Format: 00MM0000

End month

Format: 00MM0000

date1: 00050000

date2: 00100000

Restriction applies between May and October every year.

WeekOfMonth

The restriction takes effect between two weeks of every month. Week 1 begins on the first Sunday of the month.

Start week

Format: 000w0000

End week

Format: 000w0000

date1: 00010000

date2: 00030000

Restriction applies between the 1st and 3rd week of every month.