If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

MsAccess question

mewso · 2000-06-09 12:01:00

I'm programming a website in asp to display database info. My problem is that MsAccess is displaying dates the american way ONLY when the date is in code, it displays dates correctly in a table etc. Whatever causes the code to use the american date format is also resulting in dates being displayed the american way on the…

09-06-2000 1:01pm

#1

mewso

Moderators, Science, Health & Environment Moderators Posts: 8,985 Mod ✭✭✭✭

Join Date: February 1998

Posts: 8371

I'm programming a website in asp to display database info. My problem is that MsAccess is displaying dates the american way ONLY when the date is in code, it displays dates correctly in a table etc. Whatever causes the code to use the american date format is also resulting in dates being displayed the american way on the asp page. I could use vb script to force the date to display the way I want but I just thought there might be a simple reason for this. Regional settings are correct so I'm mystified.

M

0

Comments

#2 09-06-2000 1:44pm

Pretence

Closed Accounts Posts: 492 ✭✭

Join Date: May 2000

Posts: 437

Thats just the way it is. There is a function also that gives you the GMT. U could extract day, month, year from that, but if you have code written you might as well use that.

0