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!

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

DateTime field 2

Status
Not open for further replies.

DaveCrate

Technical User
Jan 12, 2004
41
US
When fields from a asp form are inserted into a table, can the date and time of that insert be inserted as a field with it.

example: table
field name: ProductName, Produced, DateProduced, DateEntered
row: Part1 1000 01/06/2005 01/07/2005 09:42 AM
 
Got it!
Thank you Lothario and R937 for the help.


here it is:
strSQL = strSQL & " GetDate()); "

I glanced @ a previous post by you L and if I would've done what you said to do, I would have had it before. Thanks for putting up with me
Thanks for both of your time!
 
Since they solved your problem, how about giving them a star for their time and work?

How do you give stars?

On the post(s) that solve the problem, find the "Thank <name here> for this valuable post!" It's in the bottom left corner of the post. You only have to do it once per poster.

-SQLBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top