Solved

DATE FORMATS. BRITISH OR AMERICAN?

Posted on 1997-12-30
1
786 Views
Last Modified: 2006-11-17
Is it a function of access that changes the format of the date from amarican to british or is it a system function??
How can I change it if it an Access function??
0
Comment
Question by:JGWYNN
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
cekman earned 10 total points
ID: 1963914
You have two places to change date formats. Long and short date formats are set in your regional settings of your computer. Go to MyComputer, Control Panel, Regional Settings.

Whatever you have set here will be used when you choose long or short date format in Access.

Otherwise you can format a date anyway you want by using the format property for the date field you're working with. Look in your on-line help for specific examples of how to use the format function to display a date in a particular way.

Good Luck!
CEkman
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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