Resolved: make a rule to sort files by financial year

[BrianGilbert]

When I scan documents I name them based on the date received, eg. 2014-12-13....

I'd like to make an action to sort these files into a subfolder based on the financial year they apply to, which in Australia is July 1 - June 30, the rule should ideally create the year folder automatically when required.

My psuedo code based thinking for it:

Code: Select all

if (filename month less than 06) {
  move to folder named based on filename year
}
if (filename month greater than 07) {
  move to folder named based on filename year +1
}

Can anyone suggest how I might go about it please?

[BrianGilbert]

Half way there

for the other half.. Is there a way to increment the year value by 1 in the subfolder creation step?

[BrianGilbert]

Indeed there is!

[Mr_Noodle]

Images aren't coming through for me here but glad you got it working.