I'm looking for some guidance or assurance that a theory I have in place will work accuratley using a Date field in a Smart Campaign.
The goal of what I am trying to do (or see if it is possible) is:
Be able to load a list once a week or one a month that send a payroll reminder on the day of each records Payroll Date.
Right now my theory is what if I had a Smart Campaign and in that campaign the Smart List was defined as:
A) MEMBER OF LIST = list I am uploading into weekly/monthly, and
B) the Date Field (which would be a filter not trigger - let's call it 'Payroll Date' ) = IN TIME FRAME of TODAY.
The flow would be Send Email
For the Schedule I would set it to be Reoccuring on a Daily basis.
My question is pretty simply is this possible? Would the program be able to read and know that say the first 100 records in the list have Monday's date, the next 100 have Tuesdays date and to only send to the specific people on those dates? So when TODAY is Monday then only the 100 Monday records get the email, and then when TODAY is Tuesday, then only the 100 Tuesday people get the email, etc.
Hopefully that makes sense.
Thanks!
Stacy