• You can't reference an alias in the same query, except in an ORDER BY clause.

    You need to use your select statement inside another one (as an inner query) and reference your alias in the outer query, or you just need to reuse the expression that calculates [Scheduled For].

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP