Keep one variable within the time constraints of another variable
I have one variable, Discharge Date & Time that is controlled on the database side with a discharge date prompt. The discharge dates will always fall within the specified time i.e. 'Last Week'. The variable that I want to have controlled by these dates is the Clinical Event End Date & Time. How can I have this variable only show dates that fall between the dates that Discharge Date & Time fall on?