My xls output from POS software has separate columns for Month and Day. I would like to use automation to send an email to everybody that has a birthday, 1 week before their birthday. I can't find a way to use data from the 2 separate fields to trigger a "date" workflow. Any ideas?
One thing I would point out is that, after following the instructions in this video, you will want to save the sheet as a CSV file. Saved as an XLS file, those fields will actually contain the FORMULA used to create the date. When you save it as a CSV file, it will "print" those values to the field, which is what you want to import into Emma.