Access/ASP Date problem

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi guys

I have a small problem with my ASP page that connects to an Access table.

I have a date field in my table that has a date field with a default value of NOW()

The date within Access shows 14/09/2006 17:00:02. This is fine.

although when i try to display that information in my ASP page it displays as 9/14/2006 5:00:02 PM

I'm in the UK so want to display the date as 14/09/2006. Why does my page change things around when Access displays correctly. How can I solve it without endless code to format it?

Thanks
Mark