philfer
01-25-2008, 12:44 PM
I am using an input box to get the report date as follows :-
Dim reportdate as Date
reportdate = InputBox "Enter the report date......etc
After this I do :-
If reportdate = "" Then
End If
to try to capture the scenario that the user presses Cancel
I get a Type Mismatch
I need the reportdate as a date as I do date calculations on it later.
I have tried :-
If Cstr(reportdate) = "" Then
but it still doesnt work
Help!!
Dim reportdate as Date
reportdate = InputBox "Enter the report date......etc
After this I do :-
If reportdate = "" Then
End If
to try to capture the scenario that the user presses Cancel
I get a Type Mismatch
I need the reportdate as a date as I do date calculations on it later.
I have tried :-
If Cstr(reportdate) = "" Then
but it still doesnt work
Help!!