HTML not working for including a field within a text

Question

I'm trying to pull in a field within text in a rich text formula field. New to html and QB rich text fields.

"<div style=\"font-size: 14px;font-weight:bold;\"align=\"center\">ABC, INC. CONSULTING AGREEMENT</div>"&"<br>"&

"<div style=\"font-size: 14px;\">Consulting Agreement (this Agreement) is made as of [Today] and is a binding agreement.</div>"

[Today] is the field I want to pull in but this actually puts "[Today]" in the field and not the actual date. Any ideas on where I went wrong? My [Today] formula field works perfectly. I want to be able to do the same with [Name] and [Address] within other text but thought I'd start with the date.

------------------------------
Dawn Rene
------------------------------

keithjusas · Answer

try this..."&lt;div style=\"font-size: 14px;\"&gt;Consulting Agreement (this Agreement) is made as of " &amp; [Today] &amp; " and is a binding agreement.&lt;/div&gt;"------------------------------Keith Jusas------------------------------

adiskljajic · Answer

Use the following format "&amp;Today()&amp;" it should work fine. Also you can format it using the following method "&amp;ToDate(Now())&amp;". I believe that should be sufficient.------------------------------Adis Kljajic------------------------------

dawnrene3 · Answer

Thank you! Worked perfectly!------------------------------Dawn Rene------------------------------

Forum Discussion

HTML not working for including a field within a text