I am trying to retrieve the value from an Access database in ASP.net VB.
The database connection does work fine although for the display of the date field i get an error.

The string was not recognized as a Valid Date Time. There is an unknown word starting at index 0.

The date is created in the Access database with the default value Now()
I have tried all the .Net data formats available in Dreamweaver but none of them gave me the result i needed or even displayed any part of the date at all.

Any help on this topic would be appreciated.
Thx.

Hi xirco

Just a thought, have you tried the value Date() ?

Have had a similar problem and it turned out ok when I set the value to Date() and modified it in DW to show the form of date I wanted.


Regards,
Sarre

Hi Sarre,

I will give the Date() a try.
Currently I used a string to bring the date from the form into the Access database.
I agree this is not the best method but since the date won't be changed or reformatted afterwards it is an acceptable solution.

A few weeks ago I found a topic on the Macromedia support site concerning this issue. Only till now I didn't manage to find it back.

Thx for your help,
Xirco.