Set PARAM_EFFECTIVE_DATE within a UNION

Summary

Combine results of 2 analysis when one has an effective date

Content

I have two reports with the same columns and I am combining them with a UNION. However one analysis will be run as of today and the 2nd analysis needs to have an effective date using "SET VARIABLE PARAM_EFFECTIVE_DATE"

Is there any way to combine these two analysis with UNION? With SQL I get an error if I apply the SET VARIABLE PARAM_EFFECTIVE_DATE clause after the UNION.

e.g. 

UNION

SET VARIABLE PARAM_EFFECTIVE_DATE='2022-01-01';

SELECT...etc

 

Thanks!