Date format in MS ACCESS

Wouldn't you want the date presented in the User's local format?

You can use:

FormatDateTime(Date(),vbLongDate)   ' or shortdate

(also, I assume you mean you are accessing the 'Access' database via asp, not writing  asp from within Access)


Pete

Yeah that's right i am accessing the Access database via asp. But the date format should be the dd/mm/yy

Yeah that's right i am accessing the Access database via asp. But the date format should be the dd/mm/yy

Well there is general date format function here:
http://www.peterweighill.co.uk/asp.html

Pete

Any formatting you do in Access isn't going to be automatically reflected in your web page.

But I’m reading the date from an access table

Access formatting is for Access users.

You are NOT using Access.  You are using the data tables part of an Access application.
The tables are managed by a completely separate program called JET.  That is why you use the JETOLEDB provider not an Access OLEDB provider.  

The 'Access' part of MS-Access is the bit that enables you to create a user interface and process the data in the tables.
You are using a different UI tool so all you have is what is contained in the JET table definition which is much less than Access allows you to specifiy.

You have to assume that you just have raw data values in the table.  Everything else is down to you with your front-end design.

Pete

so you are telling me i should specify the format in my vbscript code, and if that's so is ther a function for that?

so you are telling me i should specify the format in my vbscript code, and if that's so is there a function for that?

I think the functions you need have already been mentioned above.

As i said before:
Well there is general date format function here:
http://www.peterweighill.co.uk/asp.html

Pete

With asp accessing the database there are two ways to deal with it.

First and simplest is to go to the operating system and change the way it displays the date.
To do this:
   Control Pannel => Regional Settings => Date

NOTE: This will effect all settings on the server including file save dates on the shares.

Second is to change your ASP code.
Format(vMyDate,"dd/mm/yyyy")

Thorkyl

?Format()
In Vbscript?

Pete

Vbscript doesn't know the function format()

Is there a way to format the date read from the access table to an european date format that is dd/mm/yy i'm looking for a built in funtion like foratdatetime()

'i'm looking for a built in funtion'

There isn't one.

Pete

if your looking for a built in function then you will need change the OS settings on the server.

Access does not control the way dates are displayed in any application except Access only the way they are stored.

Thanks positronic, it worked. U r a life saver!