If you want to evaluate the date first why not place the test code before the inputbox line of code?
You also do not have any Error Trapping in your code, so if you do get an error you may not aware of it.