Cannot use AMPScript altered LookUp date field in another LookUp in an Email

Cannot use AMPScript altered LookUp date field in another LookUp in an Email

Marketing Cloud Sending

Last updated 2018-12-27 ·Reference W-4610874 ·Reported By 1 users

In Review

Summary
When an Email Send uses AMPScript to LookUp a Date field on a data extension, alters it using a Date function, and then uses it in another LookUp, the email build fails and cannot be sent.

Repro
The following AMPScript psuedocode can be used to reproduce this issue:

set @d = Lookup("de1","datefield","someColumn",@someValue)

set @d = DateAdd(@d,'-1','D')

set @rows = LookupRows("de2","datefield", @d)

Workaround
Add the modified date field directly to the Data Extension rather than modifying it with a Date function.

Reported By (1)

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.