8 Replies Latest reply: Dec 30, 2016 8:21 AM by Alejandro Cortada RSS

    NPrinting / HTML Report / email body / formula question

    Michael Reagan

      Hello All -


      I'm trying to create an HTML report to embed into the body of an email. So far so good, but I've run into a problem.


      In the HTML report, I've created Formulas that will represent dates in the main report. An example is  =Date(Max(WeekStart),'MMM D')




      I added it to the HTML:


      <li>"Current" represents the week of %%Current%%


      When I preview the report, it works great.




      But when I test the task, the email body shows:


      • "Current" represents the week of %%Current%%




      Why does it work in a browser, but not in the email distribution?