Hi
Can you show us what you have set up to date - and is it working?
I have a blog post here and solution on Xchange here if they are any help:
https://community.nintex.com/community/build-your-own/blog/2016/05/23/site-workflow-document-review-date-approaching-reminders
https://community.nintex.com/docs/DOC-4147
Looks like you want to send reminders where the task is not complete and the due date <= a week from today is that correct?
what exactly you mean with 'here is what I stucked'? do you mean condition on complete status do not work?
does your query work with only date condition?
I would say there is no problem with your condition on status but rather with date condition. you provide there variable of datetime datatype whereas CAML expects date string in ISO format.
see following posts https://community.nintex.com/search.jspa?q=%22iso+format%22&author=%2Fpeople%2F8567
Thank you so much for your help.
>Looks like you want to send reminders where the task is not complete and the due date <= a week from today is that correct?
→Yes you are correct. one condition "due date" does work but the other one "status" does not work. in my word document, I made a mistake to set "ステータス is equal to Complete" but correctly this one is "ステータス is not equal to Complete". but it does not work correctly.
Is this setting correct where I pointed out on Word document ? I think the filter on Query List action can filter "Status is not equal to complete".
Anyway, I will read your article !
oops sorry I didn't see your attachment!
>Can you show us what you have set up to date - and is it working?
I'm sorry for my poor understanding .. which picture you want to see ?
Thank you for everyone. actually it was worked well after that. I don't know why it didn't work at the moment.
I have one more question how I set the reminder with 7 days after due date.
Is it correct to set "-7" in day value on Calculate Date action ?
Yes you can use -7 in calculate date. Please mark an answer correct to close out the thread. Thanks
