var Number Sun = 0;
var Number Mon = 1;
var Number Tues= 2;
var Number Wed = 3;
var Number Thurs = 4;
var Number Fri = 5;
var Number Sat = 6;
var Number SLAStartingDay = DayOfWeek(ToDate([Date Created]));
var Text MonBHStart = ToText([Call Type - SLA Hours Start - Monday]);
var Text MonBHEnd = ToText([Call Type - SLA Hours End - Monday]);
var Text TuesBHStart = ToText([Call Type - SLA Hours Start - Tuesday]);
var Text TuesBHEnd = ToText([Call Type - SLA Hours End - Tuesday]);
var Text WedBHStart = ToText([Call Type - SLA Hours Start - Wednesday]);
var Text WedBHEnd = ToText([Call Type - SLA Hours End - Wednesday]);
var Text ThursBHStart = ToText([Call Type - SLA Hours Start - Thursday]);
var Text ThursBHEnd = ToText([Call Type - SLA Hours End - Thursday]);
var Text FriBHStart = ToText([Call Type - SLA Hours Start - Friday]);
var Text FriBHEnd = ToText([Call Type - SLA Hours End - Friday]);
var Text SatBHStart = ToText([Call Type - SLA Hours Start - Saturday]);
var Text SatBHEnd = ToText([Call Type - SLA Hours End - Saturday]);
var Text SunBHStart = ToText([Call Type - SLA Hours Start - Sunday]);
var Text SunBHEnd = ToText([Call Type - SLA Hours End - Sunday]);
var Text DayOneBHStart = if($SLAStartingDay = $Mon, $TuesBHStart, $SLAStartingDay = $Tues, $WedBHStart, $SLAStartingDay = $Wed, $ThursBHStart, $SLAStartingDay = $Thurs, $FriBHStart, $SLAStartingDay = $Fri, $SatBHStart, $SLAStartingDay = $Sat, $SunBHStart, $SLAStartingDay = $Sun, $MonBHStart, "08:00");
var Text DayOneBHEnd = if($SLAStartingDay = $Mon, $TuesBHEnd, $SLAStartingDay = $Tues, $WedBHEnd, $SLAStartingDay = $Wed, $ThursBHEnd, $SLAStartingDay = $Thurs, $FriBHEnd, $SLAStartingDay = $Fri, $SatBHEnd, $SLAStartingDay = $Sat, $SunBHEnd, $SLAStartingDay = $Sun, $MonBHEnd, "18:00");
var Text DayTwoBHStart = if($SLAStartingDay = $Mon, $WedBHStart, $SLAStartingDay = $Tues, $ThursBHStart, $SLAStartingDay = $Wed, $FriBHStart, $SLAStartingDay = $Thurs, $SatBHStart, $SLAStartingDay = $Fri, $SunBHStart, $SLAStartingDay = $Sat, $MonBHStart, $SLAStartingDay = $Sun, $TuesBHStart, "08:00");
var Text DayTwoBHEnd = if($SLAStartingDay = $Mon, $WedBHEnd, $SLAStartingDay = $Tues, $ThursBHEnd, $SLAStartingDay = $Wed, $FriBHEnd, $SLAStartingDay = $Thurs, $SatBHEnd, $SLAStartingDay = $Fri, $SunBHEnd, $SLAStartingDay = $Sat, $MonBHEnd, $SLAStartingDay = $Sun, $TuesBHEnd, "18:00");
var Text DayThreeBHStart = if($SLAStartingDay = $Mon, $ThursBHStart, $SLAStartingDay = $Tues, $FriBHStart, $SLAStartingDay = $Wed, $SatBHStart, $SLAStartingDay = $Thurs, $SunBHStart, $SLAStartingDay = $Fri, $MonBHStart, $SLAStartingDay = $Sat, $TuesBHStart, $SLAStartingDay = $Sun, $WedBHStart, "08:00");
var Text DayThreeBHEnd = if($SLAStartingDay = $Mon, $ThursBHEnd, $SLAStartingDay = $Tues, $FriBHEnd, $SLAStartingDay = $Wed, $SatBHEnd, $SLAStartingDay = $Thurs, $SunBHEnd, $SLAStartingDay = $Fri, $MonBHEnd, $SLAStartingDay = $Sat, $TuesBHEnd, $SLAStartingDay = $Sun, $WedBHEnd, "18:00");
var Text DayFourBHStart = if($SLAStartingDay = $Mon, $FriBHStart, $SLAStartingDay = $Tues, $SatBHStart, $SLAStartingDay = $Wed, $SunBHStart, $SLAStartingDay = $Thurs, $MonBHStart, $SLAStartingDay = $Fri, $TuesBHStart, $SLAStartingDay = $Sat, $WedBHStart, $SLAStartingDay = $Sun, $ThursBHStart, "08:00");
var Text DayFourBHEnd = if($SLAStartingDay = $Mon, $FriBHEnd, $SLAStartingDay = $Tues, $SatBHEnd, $SLAStartingDay = $Wed, $SunBHEnd, $SLAStartingDay = $Thurs, $MonBHEnd, $SLAStartingDay = $Fri, $TuesBHEnd, $SLAStartingDay = $Sat, $WedBHEnd, $SLAStartingDay = $Sun, $ThursBHEnd, "18:00");
var Text DayFiveBHStart = if($SLAStartingDay = $Mon, $SatBHStart, $SLAStartingDay = $Tues, $SunBHStart, $SLAStartingDay = $Wed, $MonBHStart, $SLAStartingDay = $Thurs, $TuesBHStart, $SLAStartingDay = $Fri, $WedBHStart, $SLAStartingDay = $Sat, $ThursBHStart, $SLAStartingDay = $Sun, $FriBHStart, "08:00");
var Text DayFiveBHEnd = if($SLAStartingDay = $Mon, $SatBHEnd, $SLAStartingDay = $Tues, $SunBHEnd, $SLAStartingDay = $Wed, $MonBHEnd, $SLAStartingDay = $Thurs, $TuesBHEnd, $SLAStartingDay = $Fri, $WedBHEnd, $SLAStartingDay = $Sat, $ThursBHEnd, $SLAStartingDay = $Sun, $FriBHEnd, "18:00");
var Text DaySixBHStart = if($SLAStartingDay = $Mon, $SunBHStart, $SLAStartingDay = $Tues, $MonBHStart, $SLAStartingDay = $Wed, $TuesBHStart, $SLAStartingDay = $Thurs, $WedBHStart, $SLAStartingDay = $Fri, $ThursBHStart, $SLAStartingDay = $Sat, $FriBHStart, $SLAStartingDay = $Sun, $SatBHStart, "08:00");
var Text DaySixBHEnd = if($SLAStartingDay = $Mon, $SunBHEnd, $SLAStartingDay = $Tues, $MonBHEnd, $SLAStartingDay = $Wed, $TuesBHEnd, $SLAStartingDay = $Thurs, $WedBHEnd, $SLAStartingDay = $Fri, $ThursBHEnd, $SLAStartingDay = $Sat, $FriBHEnd, $SLAStartingDay = $Sun, $SatBHEnd, "18:00");
var Text DaySevenBHStart = if($SLAStartingDay = $Mon, $MonBHStart, $SLAStartingDay = $Tues, $TuesBHStart, $SLAStartingDay = $Wed, $WedBHStart, $SLAStartingDay = $Thurs, $ThursBHStart, $SLAStartingDay = $Fri, $FriBHStart, $SLAStartingDay = $Sat, $SatBHStart, $SLAStartingDay = $Sun, $SunBHStart, "08:00");
var Text DaySevenBHEnd = if($SLAStartingDay = $Mon, $MonBHEnd, $SLAStartingDay = $Tues, $TuesBHEnd, $SLAStartingDay = $Wed, $WedBHEnd, $SLAStartingDay = $Thurs, $ThursBHEnd, $SLAStartingDay = $Fri, $FriBHEnd, $SLAStartingDay = $Sat, $SatBHEnd, $SLAStartingDay = $Sun, $SunBHEnd, "18:00");
If(
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DaySevenBHStart) <> ToTimeOfDay($DaySevenBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DaySevenBHStart)),
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DayOneBHStart) <> ToTimeOfDay($DayOneBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayOneBHStart)) + Days(1),
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DayTwoBHStart) <> ToTimeOfDay($DayTwoBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayTwoBHStart)) + Days(2),
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DayThreeBHStart) <> ToTimeOfDay($DayThreeBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayThreeBHStart)) + Days(3),
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DayFourBHStart) <> ToTimeOfDay($DayFourBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayFourBHStart)) + Days(4),
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DayFiveBHStart) <> ToTimeOfDay($DayFiveBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayFiveBHStart)) + Days(5),
ToTimeOfDay($DaySevenBHStart) > ToTimeOfDay([Date Created]) and ToTimeOfDay($DaySixBHStart) <> ToTimeOfDay($DaySixBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DaySixBHStart)) + Days(6),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DayOneBHStart) <> ToTimeOfDay($DayOneBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayOneBHStart)) + Days(1),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DayTwoBHStart) <> ToTimeOfDay($DayTwoBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayTwoBHStart)) + Days(2),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DayThreeBHStart) <> ToTimeOfDay($DayThreeBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayThreeBHStart)) + Days(3),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DayFourBHStart) <> ToTimeOfDay($DayFourBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayFourBHStart)) + Days(4),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DayFiveBHStart) <> ToTimeOfDay($DayFiveBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DayFiveBHStart)) + Days(5),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DaySixBHStart) <> ToTimeOfDay($DaySixBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DaySixBHStart)) + Days(6),
ToTimeOfDay($DaySevenBHEnd) < ToTimeOfDay([Date Created]) and ToTimeOfDay($DaySevenBHStart) <> ToTimeOfDay($DaySevenBHEnd),
ToTimestamp(ToDate([Date Created]), ToTimeOfDay($DaySevenBHStart)) + Days(7),
// General Case
[Date Created]
)
