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

convert function in Access

Status
Not open for further replies.
cards4

cards4

Technical User
Dec 9, 2004
38
US
Is there a convert function in Microsoft Access? I'm trying to convert a datetime of "mm/dd/yyyy" to "yyyy-mm-dd". Please help. Thank you.
 
Sort by date Sort by votes
Do some research on Format. I think it's what you want.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Upvote 0 Downvote
And if FORMAT isn't what you want...you are better off posting this in one of the Access forums on this site. This forum is for Microsoft's SQL Server.

-SQLBill

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
458
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
convert hierarchy structure to parent children pair please... 1
2
Replies
22
Views
658
mikrom
mikrom
grnzbra
  • Locked
  • Question
Create Function Within IF statement. 1
Replies
4
Views
487
mikrom
mikrom
briangriffin
  • Locked
  • Question
Function Returning Rowcounts
Replies
1
Views
108
briangriffin
briangriffin
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
288
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top