Having saved the profile re-open it and complete as shown below so that WiredContact knows which values to place into what field when the "trigger" runs
To have a Query that locates the correct record for a given date you need to construct your query so that you’re looking for the days/months and not the years. So you would be using something like:
Select contact, uniqueid, EmailCampaign from wce_contact where (dripfeed like '%999999%') AND ((Not Hold = 'Y') or (hold is null)) AND ((evaldayenglish = 27) and (evalmonth = 4))
Within the Site Notification Profile this looks like
Select contact, uniqueid, EmailCampaign from wce_contact where (dripfeed like '%999999%') AND ((Not Hold = 'Y') or (hold is null)) AND ((evalmonth = <#date offset=30 format=M>) and (evaldayenglish = <#date offset=30 format=D>))
Select contact, uniqueid, EmailCampaign from wce_contact where (status like '%999999%') AND ((Not Hold = 'Y') or (hold is null)) AND ((evalmonth = <#date offset=30 format=M>) and (evalday = <#date offset=30 format=D>))
For an eval date of April 27th, the above query would look like:
((evalmonth = 4) and (evalday = 27))
You’ll need to make sure your SQL formatting is correct so you use quotes when it’s a text field, and you don’t use quotes when it’s not a text field. Used in this way, you don’t have to worry about the number of days in a month. The above is looking for an expiration that is +30 days from today. If you’re using the date in a different way, you’ll have to adjust the SQL.
If you wanted to make sure you covered a date range, then you would need something like:
Select contact, uniqueid, EmailCampaign from wce_contact where (status like '%999999%') AND ((Not Hold = 'Y') or (hold is null)) AND ((evaldate >= <#date offset=25 format=sql>) and (evaldate <= <#date offset=35 format=sql)) and
((evalmonth >= <#date offset=25 mask=M>) and (evalmonth <= <#date offset=35 mask=M>)) and
((evalday >= <#date offset=25 mask=D>) and (evalday <= <#date offset=35 mask=D>))
Because of the date range, if the range goes across a month, you’ll have possibly 2 months (4 and 5 for example) with multiple days (25 through 4 for example) and you’ll need to make sure that you exclude the days that don’t belong to the correct month (in this case – if the date is in month=4 day=27, you don’t want month=5 day=27 to hit, but you do want month=5 day=3 to hit) so you need to add the complete date test to make sure you’re in the correct span.