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')

       

      Capture.PNG

       

      I added it to the HTML:

       

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

       

      When I preview the report, it works great.

       

      Capture2.PNG

       

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

       

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

       

      Capture3.PNG

       

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

       

      Thanks,

       

      mike