Date formatting (General Date to Short Date)

[Rugby83]

I am creating an online post, similar to a guestbook. When a user submits an entry, I am storing the date and time in a column titled "Timestamp", which is formatted 8/4/2005 9:16:58 ("General Date"). I am running the table through a query which is then posted on the web.

What I would like to do is this: I would like to use Timestamp to display the date that the entry was submitted, but not the time (basically, "Short Date"). Can I exclude the time using a query without changing the actual data stored in each record of the table? I understand that the time stored is completely different than the time displayed, even in the table. How can I do this?

 

[directormac]

Check Access help on the "format" command, which you can use as an expression in your query on the date field in question.

Or, if you are creating a form for the dislpay, you can change the format property of the text box to display "short date", leaving the actual data unchanged. I'm not that hip on the web part of using Access (.asp), but there should be an equivalent.

--Cloudy Mac

 

[Rugby83]

Thanks for the response. Unfortunately, I've already tried that, and when the infromation is displayed online, it reverts back to the long format. I guess, like you said, I'll have to resolve my problem on the web end.