ISSUES READING ACCESS MDB DATE AND TIME WITHIN DREAMWEAVER...NEED HELP!
Posted on 2004-10-20
Hi....hopefully, this isn't a difficult one to answer.
I am building some asp.net pages in Macromedia Dreamweaver, and am having trouble with how Dreamweaver is reading the DATE and TIME columns of the access database that is my OLE DB data connection for the data within the pages! I really don't know if this is a dreamweaver issue, ASP.NET code (OLE DB), or an MS ACCESS problem, so I may have to repost this in other categories!
Anyways...when I created the database in Access, I set up the columns for DATE and TIME as type (DATE/TIME) then adjusted the format so that it would be "Short Date" and "Short Time". THUS, the columns look like this
And so forth!
When I read the data in an ASP.net page created by Dreamweaver (or just when I test the data connections), it ends up reading like this:
Fri Aug 21 00:00:00 EDT 1998 Sat Dec 30 18:05:00 EST 1899
This is not what I want! How can I make the page read like it is shown in MS ACCESS??????????? Is this just a format issue within Dreamweaver?
Thanks for all and any help!