Move items to archive list, after date on item is so many days old

I'm going to start with some development assumptions:

• You've used "Log to history list" action to expose the values stored in variables.
  • This will allow you to verify that you've got the right information to trigger the event you're looking for
• I've not had much luck with site workflows, but this might be more suitable than as a list workflow:
  • If you go with a site workflow then you can schedule this each day
  • If you go with an item workflow, restart this within the workflow (see comment below)

From a development point of view the essence of the logic that jumps out to me is:

• Calculate Date: {Current Date} + 395
  • Use Log in History to validate that you're showing the correct date
• Query the target list to populate all IDs into a collection variable
  • This is OK so long as you're not dealing with a massive list.
  • However, given the archival strategy you'll likely be good.
• Inside a For Each Loop (using the collection variable just created):
  • Read each list item for it's Created date, comparing to your Calculated date
  • Set a Condition
    • If Created > Calculated Date
      • Copy the item over to the archive list
      • Delete the item
  • Keep calm and carry on :)

If you opt for an item level workflow approach:

• The challenge here is that the Created field is a system field, so you can't manipulate it
• Option 1:
  • Begin this with a Loop, with a Pause for 1 day action at the end
  • The risk with this approach is that at some point the workflow would want to archive the item it's running on. 
    • Include a check to ensure that you Start (this) Workflow on the item last added. 
• Option 2:
  • Collection operation to Count the number of items in the list
  • Use nIndex inside the For Each loop to grab to execute this on the latest created item
  • Inside the For Each loop Start (this) workflow on the last item
  • Pause For a day
  • This approach would remove the need for a (while) Loop. You'd effectively hop to the last created item in the list and be running this workflow one time on it.
  • Oh, and I'd add a check so that it doesn't delete the item it's running on. This would could be solved by checking for this item's ID and using Run If (this sID not equal to sCurrentLoopID)
• There are a few risks with this. Ideally though you'll pull this off as a Site Workflow, which can be scheduled each day.