How do you date/ Time stamp a recordset in an access database

[bellend]

How do you date/ Time stamp a recordset in an access database and then access the last recordset entered to view on a page? Cheers in advance?

 

[vbkris]

while inserting it do this:
<%
sql="insert into table(TheDate) values('"&now&"')"
%>

this will insert the date and time into TheDate field, u can always select the last record by:
<%
sql="select * from table order by TheDate desc"
rs.open sql,con
if not(rs.bof and rs.eof) then
response.write "Latest record -" &rs("TheDate")
end if
%>


Known is handfull, Unknown is worldfull

 

[DreXor]

sql="insert into table(TheDate) values(#"&now&"#)"

actually for access you'll need to use #'s to delim the date

other than that vbkris got everything else nailed down i think

DreX
aKa - Robert