I'm new here to Nintex and have searched several other posts that are similar to what I am looking for, but can't get my workflow to execute correctly. I'm needing a workflow to run daily that will look at the date field (date the item was scheduled) for all items, and then move any items that are over 395 days old from the scheduled date, to an archive list. I've attempted to calculate a date using, date when action is executed -395, and saving to a date/time variable. Then, query my list for when the scheduled date is less than my variable date. But, when running/executing the query no results are populating. Please help!
I'm going to start with some development assumptions:
From a development point of view the essence of the logic that jumps out to me is:
If you opt for an item level workflow approach:
Hi, Carewen. Thank you for the response!
I believe I have everything set up as you described below, with the exception of the calculate date action. I'm working with a list that is already being utilized and already has items entered. So, my calcuated date is: current date (or date when action is executed - 395). With that being said, I'm still getting the following error: