The date is a "Date" , and not a string. I was aware of DateValue, but as
you say, that requires a string to be fed to it.


"Myrna Larson" wrote in message
...
Assuming you mean your date is text (a string), use the CDate or DateValue
function.

DateValue won't include the time component, CDate will.

On Wed, 7 Jul 2004 17:08:56 -0400, "Android"
wrote:

Is there a VBA function which would convert a date into a serial number,
without you having to feed it the Year, Month, Day and time data as
individual values?

Had no luck finding it. Would make date & comparison so much easier.