Format Date Email Macro

David Moudry

• 2023年08月30日 19:02

追蹤

I am able to get a repeating table into an email using the below macro:

$XMLREPEATING2HTML(${/pd:AP/pd:processFields/pd:EngSendEmailTrigger~})

However, I am having issues getting the date to format using the below macro:

$FORMATDATETIME(${/pd:AP/pd:processFields/pd:EngSendEmailTrigger/pd:DateTime},M/d/yyyy h:mm)

Below is what I'm getting:

 

If anyone can advice on how to update the Format Date marco I'd greatly appreciate it!

Thanks!

0

• 

  Chaitra

  • 2024年01月22日 05:23

  Hi David,

  Please make use of $XMLREPEATING2HTMLWITHFILTER() macro to get repeating form data in a table with DateTime column formatted. Syntax as below:

  $XMLREPEATING2HTMLWITHFILTER(${/pd:AP/pd:formFields/pd:SubForm1_SubForm~},{TextBox3;TextBox4},{DateTime2,M/d/yyyy h:mm})

  You can ignore {Textbox3;Textbox4} parameter if you do not want to filter any columns. For more information kindly go through the below documentation link:

  https://documentation.agilepoint.com/9010/admin/cloudenvEmailTemplateConfigurationWin.html#EmailMacro

  Thanks.

  0

  評論操作 永久連結

請登入寫評論。