It is determined by the M_DATE (Member Since) date. If I sort the memberlist on that date (just click on the text in the tableheader on the members page), it shows joiedevivre as registered on 04/07/2001 and as most recent new member, just like the frontpage says....
Thnx.. then there's a problem with my registration procedure (the procedure from the forum is integrated into the website's one). think i forgot to check how my reg.asp writes the date away in the forum d/b with SQL. (just migrated from Acces)
I see. joidevivre registered on 4/7/01, that should be 7/4/01 (dutch time notation) :(
Did you change anything in the session.LCID in config.asp ?? Because this shouldn't make any difference. We designed it to use the strings for dates in the database to fix this problem.
No I didn't, and i've seen the string yes.. to be honest i don't have a clue why since the migration from acces to sql i've been having those date problems. The machine on wich the acces database resided was english windows with dutch locale, the SQL machine is english windows + sql, also dutch locale. but SQL seems to ignore that and just use US date notation for everything, unless i explicitly tell not to (in the sql statements)