You know when you create a prompted @variable for start dates, like date(x_log_sale.dt_occurred) BETWEEN @variable('1. Enter Start Date:') AND @variable('2. Enter End Date:')
If I wanted to reuse that @variable in a where statement, what do I have to do? If later on I wanted to go back and set up a where statement where the date was = @variable, what is the syntax for that?
Thanks!
Bill
If I wanted to reuse that @variable in a where statement, what do I have to do? If later on I wanted to go back and set up a where statement where the date was = @variable, what is the syntax for that?
Thanks!
Bill