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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Leading Zero to Month 1

Status
Not open for further replies.
fetemm

fetemm

Technical User
Feb 25, 2005
1
US
How do you use a query to change the Month format from 1/1/2005 to 01/01/2005

Thank you.
 
Sort by date Sort by votes
Format([Date field],'mm/dd/yyyy')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
906
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
12 Month Rolling Average 2
Replies
15
Views
1K
Swi
Swi
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
488
mikrom
mikrom
serino
  • Locked
  • Question
Adding Records between two ranges 2
Replies
12
Views
674
serino
serino
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top