Method Community

Hello - 

I would like to format the TxnDate of a sales order in an email template. 

I've added two functions to my email button on my sales order screen. 

A date function to format TxnDate and store in FTxnDate: https://imgur.com/XDXLVNY.png

And a character function to replace TxnDate within resultEmailBodyMerge with FTxnDate: https://imgur.com/mEXCjew.png

Do I then add the FTxnDate field to my email template? Can anyone give me any hints as to where I'm going wrong, please?

Hi Botanica,

I see that you have already reached out to our online chat and they have provided you with the next steps. This would require a bit of customization to achieve the desired result. 

-Inder

Hi Inder - 

Yes, thanks to your team and Tiffany I've got it working.

One of my many issues was that at the bottom of my character function, I was not reassigning the result back into resultEmailBodyMerge.

For anyone else that comes across this thread, here is my complete solution to formatting dates in my email template.

I added three actions before the Show Email and Send Email actions in my Email button. And in my email template I use the string resultTxnDate.