Input Date Parameters

Hi Everybody,
I have written a macro which pulls data from a database in to an Excel sheet and then performs certain actions on it. The SQL query that I have used to pull the data uses date parameters. I have to edit the date parameters in the macro every time I run the query. Can someone please advise, how can I tweak the macro to prompt for date input, every time it is run?

The SQL script in the macro is as below. I have colored the parts red, where the date input is required.

Please Login or Register  to view this content.

I would highly appreciate if you someone can help !!!!
Thanks... Murtaza

In the early part of the sub ask the user for the date (either by Input Box or Date Picker form). Set their reply to a variable. In the SQL string, replace the date part with

Please Login or Register  to view this content.

. You will need to make sure the variable is in the correct format for the SQL to process and also have an early exit/error handlers to prevent garbage data from the user in the date request section.

By using an InputBox (which you would need to validate the users input to prevent them entering non-dates) or by using a Date Picker as I said.

I never use an InputBox for dates so I can't help you with that, I always use a Date Picker. Demo attached FYI. However the DatePicker method is far more advanced for a novice.

Maybe someone else can explain to you how to get a date using an InputBox.