hitesh — Tue, 03 Apr 2001 15:25:59 +0000

Thanks

Will try that,

Hitesh

Peter J. Boettcher — Tue, 03 Apr 2001 15:23:21 +0000

That is strange, looks like maybe you're getting some people with different regions posting stuff and you're not formatting the date/time before you save it. Access should be translating this to the proper format but it's not.

Maybe try using FormatDateTime to clean up the date when saving/displaying it. ASP Sample:

<?php
Response.Write "Posted on: " & FormatDateTime(AccessRS("General_Date"),2)
?>

FormatDateTime uses the regional settings on the server to display the date/time so if your server is in the UK then I would think it should display this in the right format.

hitesh — Tue, 03 Apr 2001 15:11:38 +0000

Hi,

Under the heading on Last Post sometimes it says the following

01/03/22 02:48:08
yy/mm/dd - american format?

22/03/01 02:48:08
dd/mm/yy - british format?

Hope this makes sense??

I will have to wait and see, the date format changes sometimes when someone posts a new message, I'll just have to wait and see if this happens.

Hitesh

Peter J. Boettcher — Tue, 03 Apr 2001 14:46:53 +0000

Hitesh,

I had a look at the website and all the date/time strings looked like they were in the same format. I'm not sure what you mean by British format, could you elaborate on that.

For formatting you can modify the date/time field in access to display a format you're happier with, or you can format it with ASP using built in functions like MonthName/WeekdayName/Year etc.