RESOLVED: Data Model not accepting CASE statement
RESOLVED (LOOK AT THE COMMENTS): Using SQLConnect, I can get this section of code to run just fine and return the expected results (which is a monetary, Year-To-Date value)... (of course, I'm omitting the rest of the query for purposes of simplicity because I've already narrowed this CASE statement as the problem-child):
,CASE
WHEN PPOS.DATE_START > (SELECT MIN(ptp_1.START_DATE) FROM PAY_TIME_PERIODS PTP_1 WHERE PTP_1.PERIOD_NAME LIKE '1 ' || :FourDigitCurrentYear || ' Biweekly')
THEN ROUND((ROUND(:MonthBeginDate - PPOS.DATE_START,2) / 365 ),2) * CS.ANNUAL_SALARY * PCAA.PROPORTION
WHEN PPOS.DATE_START <= (SELECT MIN(ptp_1.START_DATE) FROM PAY_TIME_PERIODS PTP_1 WHERE PTP_1.PERIOD_NAME LIKE '1 ' || :FourDigitCurrentYear || ' Biweekly')