• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 434
  • Last Modified:

Date Format in Access 2003

I am working in Access 2003 and need to change the date format to DAY/MONTH/YEAR.

I cannot figure out how to do this.  Can you help?
0
sweetcin15
Asked:
sweetcin15
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
your regional setting is Pacific?

format(Date,"dd/mm/yyyy")

or

cvdate(format(Date,"dd/mm/yyyy"))

0
 
MiddlesbroughPCTCommented:
go into the table design view,
select the date field,
within format from the drop down box select option.

0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now