Help with formula?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Current works fine:
var text MyConcatenatedFields =
List(" | ", (ToText([PPP.Effective Date])),[Per Plan Price (PPP) Name]);

If(
ToText([PPP.Effective Date])>"10-31-2016", "<b><font color=RED>"& $MyConcatenatedFields & "</font color></b>",
$MyConcatenatedFields)

BUT, if I enter PPP.Effective Date of 01/03/2017, the concatenated field does not turn red.  Please advise.  Thank you
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
try this



If(
[PPP.Effective Date] >ToDate("10-31-2016"), "<b><font color=RED>"& $MyConcatenatedFields & "</font color></b>", 
$MyConcatenatedFields)
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb
It works.  Thx
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
Great, thx for letting me know.