In my WF, I have a requirement to send an email notification 6 months before an expiry date. The expiry_date is a list column and would be supplied by the user, so I get the value in my Nintex WF directly.
However, I'm a little confused about what's the best approach to do this. My current approach is:
1. Create a new workflow variable called "Reminder_date" and use the Calculated date action to subtract 6 months from my expiry_date and store the date in Reminder_date.
2. Use an inline function DateDiffDays(expiry_date,Reminder_date) and store the difference in another variable(say, difference_days).
3. Check if difference_days < 180 then send the email notification.
I've already done step 1. I'm not sure what action are best suited for Step 2 and 3. Any help is mush appreciated.