Date Template

Configuration specific for date table template. Bravo has a simplified configuration and assigns the same First Year value to both FirstYearMin and FirstYearMax, and the same Last Year value to both LastYearMin and LastYearMax.

FirstYearMin

If defined, it is the minimum value for the first year generated in the Date table. If the year found by the automatic scan is less than FirstYearMin, then the Date table will start from the FirstYearMin year.

FirstYearMax

If defined, it is the maximum value for the first year generated in the Date table. If the year found by the automatic scan is greater than FirstYearMax, then the Date table will start from the FirstYearMax year.

LastYearMin

If defined, it is the minimum value for the last year generated in the Date table. If the year found by the automatic scan is less than LastYearMin, then the Date table will start from the LastYearMin year.

LastYearMax

If defined, it is the maximum value for the first year generated in the Date table. If the year found by the automatic scan is greater than LastYearMax, then the Date table will start from the LastYearMax year.

HolidaysReference

Configuration for holidays used to create working and non-working days in the Date table.

IsEnabled

Use true to generate the Date table using the Holidays table, or false to ignore holidays related information.

TableName

Name of the Holidays table.

DateColumnName

Name of the column of Date data type in the Holidays table.

HolidayColumnName

Name of the column of type string containing the name of the holiday for each corresponding date in the Holidays table.