ExactTarget AMPscript: Issue with links not working when URL is pulled from data

Here’s the scenario. We had links where the URL was populated from the data. The field was called “URL”, and it contained URLs without the http://. So, my code looked like this: <a href=”http://%%URL%%”>%%URL%%</a> Pretty straight forward. Well, the data extension that was used for the email send, would get updated after the blast.  What … Continue reading ExactTarget AMPscript: Issue with links not working when URL is pulled from data

Format date/time via AmpScript

—————————- Today’s Date Substitution String (Short Date Format): %%xtshortdate%% 8/14/2011 —————————- Today’s Date Substitution String (Long Date Format): %%xtlongdate%% Sunday, August 14, 2009 —————————- Today’s Date MM/dd/yyyy: %%=Format(Now(),”MM/dd/yyyy”)=%% 08/14/2011 —————————- Today’s Date plus 7 days (no formatting): %%=DateAdd(Now(), “7”,”D”)=%% 8/21/2011 10:05:55 PM —————————- Today’s Date plus 7 days (with formatting – no time): %%=Format(DateAdd(Now(), “7”,”D”), … Continue reading Format date/time via AmpScript

AmpScript – check if field is not empty and render table row with odd/even color scheme

The ask was that the email needed to show tabular data from fields only if the fields were not empty, and they wanted to have an odd/even table row color scheme for readability. If this were JavaScript I would have created an array and then just looped through the array. But I didn’t know how … Continue reading AmpScript – check if field is not empty and render table row with odd/even color scheme