Resolved: make a rule to sort files by financial year

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:
Can anyone suggest how I might go about it please?
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?