conditional for last recent gift online/offline

Nikki Valentine Odens

I sent and email with a conditional for a specific group that said "Thank you for your last gift on <date>!"

The conditional "Last transaction date," I assumed would pull from their record either online or offline gift. We had a donor

that was upset because it pulled his last online gift which was in 2009 and he had given money through mail in May of 2010.

On his constituent360 information is says last external gift was in May 2010. How come the conditional in the WYSIWYG didn't pull that information?

Does anyone know how I can get it to pull "Last external gift"  so it's works for both online/offline donations?

Thanks

Noah Cooper

Last Transaction Date actually only pertains to online gifts. To display the most recent of Last Transaction Date and External Last Gift Date, you can do something like this:

]x]x::
     <!--last_trans_date is null, external_last_gift_date is null-->
::
]x::
     <!--last_trans_date is null, external_last_gift_date is not null-->
     ]
::
]x::
     <!--last_trans_date is not null, external_last_gift_date is null-->
     ]
::
     <!--last_trans_date is not null, external_last_gift_date is not null-->
     ]:YYYY-MM-dd]] ]:YYYY-MM-dd]] >]]::1::
          <!--external_last_gift_date is more recent than last_trans_date-->
          ]
     ::
          <!--last_trans_date is more recent than external_last_gift_date-->
          ]
     ]]
]]]]]]

Nikki Valentine Odens

Noah Cooper:

Last Transaction Date actually only pertains to online gifts. To display the most recent of Last Transaction Date and External Last Gift Date, you can do something like this:

]x]x::
     <!--last_trans_date is null, external_last_gift_date is null-->
::
]x::
     <!--last_trans_date is null, external_last_gift_date is not null-->
     ]
::
]x::
     <!--last_trans_date is not null, external_last_gift_date is null-->
     ]
::
     <!--last_trans_date is not null, external_last_gift_date is not null-->
     ]:YYYY-MM-dd]] ]:YYYY-MM-dd]] >]]::1::
          <!--external_last_gift_date is more recent than last_trans_date-->
          ]
     ::
          <!--last_trans_date is more recent than external_last_gift_date-->
          ]
     ]]
]]]]]]

Thank you I will try this.