How to add a Date/Time field within the display text of a Rich Text Field

Question

I want to be able to add the date/time field shown below to the right to the rich text field I have to the left:

I'm not sure how to add it to the display text of my rich text field; the field formula is currently:If([PO Submitted]=true, "&lt;div style=\"height:20px;width:395px;padding:10px;color:black; font-size: 12pt; background-color:lightgreen;\"&gt;&lt;b&gt; This Purchase Order has been submitted to the Vendor on &lt;/b&gt;&lt;/div&gt;")What would be the best way to do this - Do I create more html formatting an implement the date/time within that?
------------------------------Niraj Shah------------------------------

markshnier__you · Answer

try tbhisIf([PO Submitted]=true, "&lt;div&nbsp;style=\"height:20px;width:395px;padding:10px;color:black;&nbsp;font-size: 12pt; background-color:lightgreen;\"&gt;&lt;b&gt;" &amp; ToText([my date / time field]) &amp;&nbsp; "&lt;/b&gt;&lt;/div&gt;")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

nirajshah4 · Answer

Thank you, Mark! It worked wonderfully.ᐧ

Forum Discussion

How to add a Date/Time field within the display text of a Rich Text Field

Related Content

Display Thumbnail Image

Formula Date Time Will not Accept Null Condition

Date/Time format

Convert date and time to date/time

Convert timestamp to Date/Time