ISDATE function in VBA evaluating to false and i dont know why

Hi, i have a macro where i use the vba function ISDATE.

I pass the isdate function two date formats.........but for some reason both evaluate to "false" and i am not sure why.

i am enclosing small macro to show the problem i am having........

Any ideas?

Hi,

you are using the Value2 property and it returns a Double data type if the original data in the range is Date. Try using the Value property.
http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Note: you didn't declare some of your variables, not sure if that's intentional.

If you change this line

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

thanks....i will take a look at your suggestions

during the time i posted this question........the server went dead for this web site...........during that time i was thinking about what to do.......

i came up with this idea of a validDate function.........it seems to work......i am going to include it below.......but it figures that i would go to a "long" soln when (looking at the suggestions thus far) when the real soln might be very simple.

Please Login or Register  to view this content.

this is not the first time i have run across the ".value" vs ".value2" issue.

Any suggestions on when to use one vs the other? I read something somewhere that i should always use the ".value2" which is why i use it all the time.......but from time to time when working with dates i have an issue but not all the time.

any suggestions/advice?