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?
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.
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.