Solved

Date format in MS ACCESS

Posted on 2003-11-03
19
9,695 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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
 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

813 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

8 Experts available now in Live!

Get 1:1 Help Now