Date and Time Category Functions

Functions in the following category can be used to execute business logic using Date and Time values. For example, you can use the functions to convert Strings to Date or to calculate the number of days between two Date values.

Rule ID	Name	Long Description
SCC_RULE_ID_20120711162453	GetCurrentDate	Gets the Current Date from the System.
SCC_RULE_ID_20130513065254	DaysToWeeks	This function takes the number of days and convert it to weeks, truncating the calculated value.
SCC_RULE_ID_20130509114010	YearsBetweenDates	This function takes two dates and calculates the number of years, truncating any partial year between the two dates. If the Date From value is later than the Date To field, the result is a negative number.
SCC_RULE_ID_20130508165644	MonthsBetweenDates	This function takes two dates and calculates the number of months truncating any partial month between the two dates. If the Date From value is later than the Date To field, the result is a negative number.
SCC_RULE_ID_20130508164259	WeeksBetweenDates	This function takes two dates and calculates the number of weeks truncating any partial week between the two dates. If the Date From value is later than the Date To field, the result is a negative number.
SCC_RULE_ID_20130508152325	DaysBetweenDates	This function takes two dates and calculates the number of days between the two dates. If the Date From value is later than the Date To field, the result is a negative number.
SCC_RULE_ID_20120711181602	Year	Returns the year value from a date.
SCC_RULE_ID_20120711180936	Month	Returns the month value from a date.
SCC_RULE_ID_20120711180404	Hour	Returns the hour value from a time.
SCC_RULE_ID_20120711171519	SubtractYearsFromDate	Subtract a specific number of years from a date returning the calculated date.
SCC_RULE_ID_20120711171113	SubtractMonthsFromDate	Subtract a specific number of months from a date returning the calculated date.
SCC_RULE_ID_20120711165819	SubtractDaysFromDate	Subtracts a specific number of days from a date returning the calculated date.
SCC_RULE_ID_20120711165049	AddYearsToDate	Add a specific number of years to a date returning the calculated date.
SCC_RULE_ID_20120711164350	AddMonthsToDate	Add a specific number of months to a date returning the calculated date.
SCC_RULE_ID_20120711163227	AddDaysToDate	Add a specific number of days to a date returning the calculated date.
SCC_RULE_ID_20120725170243	Second	Returns the second value from a time.
SCC_RULE_ID_20120725165438	Minute	Returns the minute value from a time.
SCC_RULE_ID_20120725163802	Day	Returns the day value from a date
SCC_RULE_ID_20131119192253	StringToDate	Convert a String in the format YYYY-MM-DD to a Date.
SCC_RULE_ID_20131119193042	StringToDateTime	Convert a String to a Date Time value.
SCC_RULE_ID_20131119193911	StringtoTime	Convert a String to a Time value.