How do I define the dashboard prompt to include date range on the same column

Summary:

Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher DM Query

Content (required):

I have a BI publisher DM & Report it works fine with data template and date range parameter on hire date(2 date parameters from_date and to_date defined in DM Query) which are needed to filter on hire date column. I have enabled this on the dashboard with dashboard prompt. But I cant define 2 date prompts ( for start date and end date to give range) on the same hire date column while defining Hire Date prompt. I know to pass the date prompt as "is equal to/is in" and enable to a presentation variable defined as the BI publisher