Convert a string to a date

[Marco Trapanese]

Hi!

Why

CDate(#24/04/2007#) works but,

CDate("#24/04/2007#") doesn't?

It says: index out of bounds. Index of what matrix?
I have a string (actually a textbox) and I want to convert it to a
DateTime value. How?

Thanks
Marco / iw2nzm

[Spam Catcher]

Re: Convert a string to a date

Marco Trapanese <marcotrapanese NOSPAM@libero.i twrote in news:v3spi.7444 4
$U01.683421@twi ster1.libero.it :

CDate("#24/04/2007#") doesn't?
>
It says: index out of bounds. Index of what matrix?
I have a string (actually a textbox) and I want to convert it to a
DateTime value. How?

Try CDate("24/04/2007")

What does that return?

[Marco Trapanese]

Re: Convert a string to a date

Spam Catcher wrote:

Try CDate("24/04/2007")

It returns the same error.

Bye
Marco / iw2nzm