Formatting Dates and Time for SMS using AMPScript in Content Builder

Question

Having a format issue on a SMS in Content Builder. Can someone point me to the correct code for this?

Also would love some advice to learn basic AMPScript coding. Books? Tutorials? Online classes?

Current: This is a reminder that you have an appointment scheduled for: %%AppointmentDateTime__c%%

Displaying as:

This is a reminder that you have an appointment scheduled for: 2019-09-05TO09:30:00

Should be showing as:

This is a reminder that you have an appointment scheduled for: 9/05/19 at 9:30am.

Cameron Robert · Accepted Answer · 2019-09-17 01:00:14Z

2

You could try the FormatDate() function:

%%=v(Concat(FormatDate(AppointmentDateTime__c,"M/dd/yy","", "en-US")," at ",FormatDate(AppointmentDateTime__c,"","HH:mmtt", "en-US")))=%%

Also Adam and Eliot have some great info on AMPScript that you can follow here: https://ampscript.guide/

answered Sep 17, 2019 at 1:00

Cameron Robert

2,42313 silver badges22 bronze badges

Eliot also offers online and offline courses that address your learning goal: ampscript.academy The last one online was last week. You might contact him if there's anything coming up.
– Stephan de Paly
Commented Sep 17, 2019 at 17:30
This worked great! Thank you! I am going to devote more time in learning AMPscript. I am a newbie here.
– Chris Smith
Commented Sep 18, 2019 at 17:22
Will check out the Guide and Academy
– Chris Smith
Commented Sep 18, 2019 at 17:23

Add a comment |

1 Answer 1