I started with DateValue before searching for an answer here, thinking that
would do it. I have a breakpoint so I can see the value of
DateValue(txtDate) and it shows me the date of 11/16/2008 rather than the
serial number. I am really confused on this one. Thanks for your assistance
and any further suggestions.

"Barb Reinhardt" wrote:

My apologies. It's DateValue.
--
HTH,

Barb Reinhardt



"VinceW" wrote:

Barb,
Thanks for the quick reply, however I get the error "Sub or Function not
defined" when trying that. Any suggestions?

"Barb Reinhardt" wrote:

IIRC, you can use

DATEVAL(String) to get the serial date.
--
HTH,

Barb Reinhardt



"VinceW" wrote:

I have a text box where the user enters a date and it is assigned to variable
txtDate. How to I convert that to the serial number of the date?

Thanks for the help