Hello,
VB6 accepts Date and Time values as 'Date'. I'm trying to verify entry into
a database I'm creating by verifying that an appropriate Date or Time value
has been entered. Using built-in VB functions/properties etc., I can't seem
to unambiguously confirm that an entry is a valid date or valid time value?
(I would like to try and do this without having to write some huge procedure
that processes an entry character by character, especialy with all the
permutations that are possible) 'IsDate' recognizes date or time as 'Date',
and I can't seem to interogate the variables to confirm it's one or the
other. I've been playing around with 'DateValue', 'DatePart', 'TimeValue',
'Year' functions etc............Ahhhhhh.
A suggestion in the right direction would be appreciated.
Thanks,
Gord