Thanks for the response. However, I am still getting a different column for the day it is not appending to the DATETIME column. Any suggestions?
Thanks.
Quote:
quote:Originally posted by pgtips
Try this instead of your multiple If/ElseIf statements:
Code:
strWebLogActivityTable = strWebLogActivityTable & "<td align='left' bgcolor='#FFFF00' width='100'><b>" & trim(rs("access_date")) & "</b><br>"
strWebLogActivityTable = strWebLogActivityTable & _
WeekDayName(Weekday(rs("access_date"))) & _
"</td>"
|