Is it possible to pass a presentation variable into SQL code

Summary

Is it possible to pass a presentation variable into SQL code

Content

Is it possible to pass a presentation variable from a prompt into the SQL Code?  I am looking to insert the prompt variable into the sql on the advanced tab in the analysis.  Below is basically what I am trying to do. 

For Instance: 

Prompt_Date: 9/6/2016 

Select field 
From Table 
Where Date = Prompt_Date 
Union All 
Select Field 
From Table 
Where Date = Prompt_Date