I have a requirement to move the documents from one document library to another document library.
Source Library - DocumentLib
Destination Library - Archive
Archive document library will have folders by fiscal year.
Source documentlibrary has files from year 2012 till date.
Archive folder will have folders by fiscal year -(fiscal year starts from July1st -June 30th )
If the document is created date between 1st July 2012 -June 2013 then move the document to Archive document library and in folder Fiscal Year 2013.
If the document is created date between 1st July 2013 -June 2014 then move the document to Archive document library and in folder Fiscal Year 2014.
Please find attached the screenshot of the requirement.
Structure of destination document library folder should be same as source document library.(The columns). Files Type - Excel,pdf,microsoft outlook item
Could we use Sharepoint designer workflow to achive this task?
Any help on this will be appreaciated.