Just now, Tarun10 said:
Would Lightroom do all the things you mentioned or should I look into writing a script. Is it very complicated?
I haven't used Lightroom, only free version of Zoner and now digiKAM. Had Picasa before those. It depends a bit, but you can choose to view all files in folder/album or select files with certain attributes and them move them as bulk.
For example in DigiKAM I have one folder that is set to be main of the images I want it to search from. So viewing per date taken gives this view:
Where you can then select files and move them to another "album" (same as folder, it moves them in Windows too). Now, this requires that files have correct metadata attributes. For example some of these videos are much older than what they give out.