Returned information is not the same as displayed in the table

[networkwoes]

I have a Access 97 database that contains a date/time field. When I open the table and view the data it shows the entry as "5/2/03". However when I query the database using the .IDC files via the web interface it returns the entry as "2003-05-02 00:00:00". Can anyone tell me how to get it to return the entry without the time and in the format of "5/2/03"?

 

[RJFost]

Have you tried using Format(<date field>, &quot;m/d/yy&quot in your query? It looks like it's either 1) defaulting to the system date/time format, or 2) returning the raw date/time value. The Format() will convert it to a text value, but it'll be in the format you specified.