this is really bugging me as I can't see why this is happening.
I have a page which runs as the reult of a search, records details of the
search, it goes a bit like this.
get dearch criteria and search datebase.
if no data is found then create a record for that search, including the
search query, the search count (set to 1), and the search date.
strSQL = "INSERT INTO SEARCH_STATS (query_details, search_number,
last_search_dat e) VALUES (" & "'" & ucase(query_det ails) & "'" & ",1," &
date() & ")"
if the search data is found then increase the search count by one and amend
the last search date.
old_search_coun t = rs1("search_num ber")
new_search_coun t = old_search_coun t + 1
rs1("search_num ber") = new_search_coun t
rs1("last_searc h_date") = date()
rs1.update
now, if no search data is found then when the search record is created the
date that gets inserted is all wrong (it looks more like a time format)
if the search data is found the date that gets updated becomes correct.
what I can't figure out is how two dates() on the same page can give
different results???