Is there an elegant way to tie two date prompts together to create a single date range prompt.
For example, I have a Low Date prompt and a High Date prompt that are fed into a stored procedure that contains "ActivityDate between @LowDate and @HighDate". How do I make the Low Date and High Date prompts required so that a user must complete them both to make the stored procedure run correctly?
Thanks.
For example, I have a Low Date prompt and a High Date prompt that are fed into a stored procedure that contains "ActivityDate between @LowDate and @HighDate". How do I make the Low Date and High Date prompts required so that a user must complete them both to make the stored procedure run correctly?
Thanks.