Conditional Formatting Table Value...

[116]

I have been attempting to change how a column is displayed based on another
columns value.
If FP_FieldVal(fp_rs,"HolDate") > Date() THEN...I would like for the other
column to display as BOLD.

Thanks for any assist,
David

 

[Stefan B Rusynko]

Put that code in the other table cell that you want bold wrapping the other field ( say named: otherfield)
<td>
<% If FP_FieldVal(fp_rs,"HolDate") > Date() Then %><b><% End if %>
<% =FP_FieldVal(fp_rs,"otherfieldname") %>
<% If FP_FieldVal(fp_rs,"HolDate") > Date() Then %></b><% End if %>
</td>




I have been attempting to change how a column is displayed based on another
columns value.
If FP_FieldVal(fp_rs,"HolDate") > Date() THEN...I would like for the other
column to display as BOLD.

Thanks for any assist,
David

 

[116]

Hello Stefan, below are the columns in question and how I understood. Not
sure if placed properly, but either ALL is bold or not, depending on the < or

. Seems as if Date() is not seeing HolDate as a date?

<td style="text-align: center" width="20%" height="32"><font size="2">
<% If FP_FieldVal(fp_rs,"HolDate") < Date() Then %><b><% End if %>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="EntryID,HolYear,Holiday,HolDate,HolDay,HolPaid,HolCmnts"
s-column="Holiday" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Holiday<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Holiday")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="13897" -->
<% If FP_FieldVal(fp_rs,"HolDate") < Date() Then %></b><% End if %>
</font></td>
<td style="text-align: center" width="16%" height="32"><font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="EntryID,HolYear,Holiday,HolDate,HolDay,HolPaid,HolCmnts"
s-column="HolDate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>HolDate<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"HolDate")%><!--webbot
bot="DatabaseResultColumn" endspan i-checksum="13643" --></font></td>

David

 

[Jon Spivey]

Try casting the field value as a date
<% If cdate(FP_FieldVal(fp_rs,"HolDate")) < Date()