Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date formats

Status
Not open for further replies.
Gagsy

Gagsy

Technical User
Oct 16, 2002
56
0
0
GB
I have a table which contains a date field which uses US format (MM/DD/YYYY).

is their any command where I can change this to UK time format.

Thanks
Gagsy
 
Sort by date Sort by votes
Have you tried to just change the letters?
YY/MM/DD

Best Regardz,

Spikemannen
 
Upvote 0 Downvote
I have been trying to change it in the query and report.

I have change the query to a make table and amedned the field properties.

This appears to have worked.

Thanks
Gagsy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
122
TomSalvato
TomSalvato
nikademous
  • Locked
  • Question
Go to specific Record based on date
Replies
0
Views
36
nikademous
nikademous
PWD
  • Locked
  • Question
Access 2010 Sort By Calculated date
Replies
7
Views
91
dhookom
dhookom
billheath
  • Locked
  • Question
Picking value for the latest date in a subform
Replies
1
Views
45
billheath
billheath
PohTek
  • Locked
  • Question
Bi-weekly due dates for loan repayments
Replies
2
Views
49
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top