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

<b>SQL for inserting date </b>

Status
Not open for further replies.
jabond007

jabond007

Programmer
Jun 21, 2000
39
US
Could somebody tell me the syntax for inserting date ina date field.

The data to be inserted is 09022000. I need the SQL syntax for inserting this in the date field (format mm/dd/yyyy)

Thanks [sig][/sig]
 
Sort by date Sort by votes
DoCmd.RunSQL ("INSERT INTO TableName (FieldName ) Select #09/02/2000#")


PaulF [sig][/sig]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
1K
Andrzejek
Andrzejek
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
398
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
pankajunk
  • Locked
  • Question
I want to set up a simple meeting b
Replies
2
Views
359
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top