Method:Classic General Q&A

Re: Formatting a date in an email

botanica — Thu, 14 May 2020 17:13:07 GMT

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.

Re: Formatting a date in an email

Method_Inderdeep — Thu, 14 May 2020 15:26:52 GMT

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

Formatting a date in an email

botanica — Wed, 13 May 2020 20:04:52 GMT

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?