View Single Post
  #1 (permalink)  
Old July 24th, 2003, 07:51 AM
savoym savoym is offline
Friend of Wrox
 
Join Date: Jun 2003
Posts: 119
Thanks: 0
Thanked 1 Time in 1 Post
Default Concatenation question, please

I have a line of code where I am trying to append the actual TEXT of the day name at the end of a column where I am displaying the contents of the DATETIME. So that my column per records will look like:

DATETIME
Monday

or

DATETIME
Tuesday, etc.

I am having syntax problems and was wondering if anyone could help me by telling me where my problem is:

strWebLogActivityTable = strWebLogActivityTable & "<td align='left' bgcolor='#FFFF00' width='100'><b>" & trim(rs("access_date")) & "</b><br>"

If strday = 1 Then
 "<b>Monday</b>"
Elseif strday = 2 Then
 "<b>Tuesday</b>"
Elseif strday = 3 Then
 "<b>Wednesday</b>"
Elseif strday = 4 Then
 "<b>Thursday</b>"
Elseif strday = 5 Then
 "<b>Friday</b>"
Elseif strday = 6 Then
 "<b>Saturday</b>" & _
Elseif strday = 7 Then
 "<b>Sunday</b>" & _
strWebLogActivityTable = strWebLogActivityTable & "</td>"
Reply With Quote