Solved

Date format in MS ACCESS

Posted on 2003-11-03
19
9,677 Views
Last Modified: 2012-06-21
Hey folks,

I’m working on a dynamic website using asp and ms access . in the database I created I have a field in one of the tables with the data type date/time and the. I want the date in the format dd/mm/yyyy and I set the format in ms access just like this but it doesn’t seems to be working. It’s in the formt mm/dd/yy. can anybody tell me how I should go about it?
Thanks.
0
Comment
Question by:keroroza
  • 8
  • 6
  • 2
  • +2
19 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 9669653
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
0
 

Author Comment

by:keroroza
ID: 9669855
Yeah that's right i am accessing the Access database via asp. But the date format should be the dd/mm/yy
0
 

Author Comment

by:keroroza
ID: 9669857
Yeah that's right i am accessing the Access database via asp. But the date format should be the dd/mm/yy
0
 
LVL 77

Expert Comment

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

Pete
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 9670166
Any formatting you do in Access isn't going to be automatically reflected in your web page.
0
 

Author Comment

by:keroroza
ID: 9670196
But I’m reading the date from an access table
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9670377
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



0
 

Author Comment

by:keroroza
ID: 9670433
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?
0
 

Author Comment

by:keroroza
ID: 9670434
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?
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 30

Expert Comment

by:nmcdermaid
ID: 9670458
I think the functions you need have already been mentioned above.
0
 
LVL 77

Expert Comment

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

Pete

0
 
LVL 2

Expert Comment

by:thorkyl
ID: 9671332
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
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9671420
?Format()
In Vbscript?

Pete

0
 

Author Comment

by:keroroza
ID: 9676800
Vbscript doesn't know the function format()
0
 

Author Comment

by:keroroza
ID: 9676972
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()
0
 
LVL 77

Expert Comment

by:peter57r
ID: 9677020
'i'm looking for a built in funtion'

There isn't one.

Pete
0
 
LVL 2

Expert Comment

by:thorkyl
ID: 9678673
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.
0
 
LVL 1

Accepted Solution

by:
positronic earned 90 total points
ID: 9682454
This might be useful... it worked on our server...

http://www.webwizguide.info/asp/faq/date_time_settings.asp

If you add:

<%
Session.LCID = 2057
%>

in your ASP, it should cause dates to be displayed in UK format (i.e. dd/mm/yyyy) plus the web link has a list of all the different LCID codes for different locations.

--Simon
0
 

Author Comment

by:keroroza
ID: 9684688
Thanks positronic, it worked. U r a life saver!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now