Date Source

Script File: 

DateSource.2005.scx

DateSource.2008.scx10

DateSource.2012.scx11

DateSource.2014.scx12

Overview

Data flow source, providing separate date elements.

Setup

The script has the following parameters:

• IterationStep - specifies date sequence iteration step in days.
• Culture - selects date culture.
• IsStartDateVariable - indicates whether the start date is stored in a variable.
• • StartDate - specifies start date.
• • StartDateVariable - selects variable containing start date.
• IsEndDateVariable - indicates whether the end date is stored in a variable.
• • endDate - specifies end date.
• • EndDateVariable - selects variable containing end date.

Output columns provided by the script.

• Day - day of the month.
• DayShortName - day of week text (short).
• DayName - day of week text.
• DayOfYear - day of year.
• Week - week of year.
• Month - month.
• MonthShortName - month text (short).
• MonthName - month text.
• Quarter - quarter (Q1, Q2, Q3, Q4).
• Year - year.

Requirements

Depends on COZYROC Script Component Plus component for implementing parameters user interface.