Hi ASP experts -
I have a DateTime datatype field in my SQL Server 7 table that I want to write to the record when the record is first written and any time it is subsequently updated.
Using ASP, is there a function that will put BOTH current date and time into a DateTime field?
This is what I'm doing, but all I get in the record is date:
datCurDate = Date()
.
.
.
the SQL Insert statement has CDate(datCurDate)
TimeValue(Now()) will give me only current time.
How can I get a value containing current date and time to use for inserting into my DateTime field?
Want to do this in ASP or vbScript.
Thanks, John
I have a DateTime datatype field in my SQL Server 7 table that I want to write to the record when the record is first written and any time it is subsequently updated.
Using ASP, is there a function that will put BOTH current date and time into a DateTime field?
This is what I'm doing, but all I get in the record is date:
datCurDate = Date()
.
.
.
the SQL Insert statement has CDate(datCurDate)
TimeValue(Now()) will give me only current time.
How can I get a value containing current date and time to use for inserting into my DateTime field?
Want to do this in ASP or vbScript.
Thanks, John