Date / time ormats.
December 18, 2004 12:00 AM
Hi,What kind of date/time formats are used when test results are posted by cgi? I'm having difficulties storing date/time values in a access mdb by a asp (vbscript) script.Is there a 'output-format' list or would I be able to retrieve it myself one-way or another?Regards,Egon Kraaikamp
Discussion (2)
Aaron,I've created some output to a text-file by posting a test to a CGI(ASP) script. I don't know how to store some values in a Access time/date field. E.g.- CurrentDate: ~~f=1~~1100789280314#November 18, 2004- ElapsedTime: ~~f=4~~26919#00:00:26- CurrentTime: ~~f=2~~1100789280374# 3:48 PMFor sure I can store it in a Text-field, but would like to re-use the date/time stamp from the database.Regards,Egon Kraaikamp.
The easiest way of doing it is let Access take care of that for you. Just make the field a date/time data type with default value of Now() or Date() and it will automatically insert the date/time from the server when the row is added.You could also make the field a text type and that way you don't have to worry about conversion if you want to use the Lectora variable.
Discussions have been disabled for this post