It's working! There were other syntax errors, but fixing my understanding of how to properly do the multiple if/then statement allowed me to easily work out the rest of the issues.
<pre>
//what day of the week is it? set variables for significant days: Friday, Saturday, & Sunday
var number day = DayOfWeek(ToDate([Date Time]));
var bool isFriday = If($day=5,true);
var bool isSaturday = If($day=6,true);
var bool isSunday = If ($day=0, true);
//workday ends at 8pm Friday, so things submitted 8pm and later are considered next day
var bool isFridayEightpm = If($isFriday=true and ToTimeOfDay([Date Time])>=ToTimeOfDay("8 pm"),true);
//if a task is submitted Friday 8pm until Sunday 11:59 pm, make it due Monday 8pm
//otherwise, task is due next day, same time (24 hrs)
//in order to add the right number of days to the original timestamp, we have to check for Fri, Sat, and Sun separately
If(
$isSunday,
ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time])), 2)), ToTimeOfDay("8 pm")),
$isSaturday,
ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time])), 3)), ToTimeOfDay("8 pm")),
$isFriday and $isFridayEightpm,
ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time])), 4)), ToTimeOfDay("8 pm")),
$isFriday and not $isFridayEightpm,
ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time])), 2)), ToTimeOfDay([Date Time])),
ToTimestamp(ToDate(WorkdayAdd(ToWorkDate(ToDate([Date Time])), 2)), ToTimeOfDay([Date Time]))
)
</pre>
And here is evidence the logic also works:
http://take.ms/ZGtLG">http://take.ms/ZGtLG">http://take.ms/ZGtLGTHANK YOU!