richfeed

sQuery="SELECT * FROM personal,policy,staff "_ &"WHERE personal.name="&Request.Form("name")&" "_ &"AND personal.id=policy.id "_ &"AND policy.id=staff.id;" [connection].execute(sQuery) I never use VBScript - only J(ava)script in ASP, so syntax maybe not ideal, but you get the idea.

Greetings, I'm a late (web) developer from northwest England. That's late as in "advanced in years", not (I trust) as in "dead". Bye for now.

The second call to [B]new Date(..)[/B] is converting output to a UTCString. Simply comment out the line [B]var result=new Date(date1)[/B] and instead [B]document.write(date1)[/B]. You might also check your script lines end with";", use [B]var y=d.getFullYear()[/B], and append the zero'd time portion to the "date1" string.