Logical SQL With Dashboard Prompt

Summary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The logical SQL is working, however, I am having trouble with the prompt for effective date. We want the end user to be able to run the report between two dates but when I use the prompt on the dashboard, it does not seem to affect the report at all. The prompt spins and doesn't change the result set. I am attaching the folder with the report, the dashboard prompt and the