Concatenate metadata to rename using AppleScript or smart rules

I hadn’t noticed the “Document Date” category before - the manual says:

So it doesn’t look like it does what you want to achieve (but @bluefrog will know).

I’m not sure if it is the same thing as you tried, but I’ve achieved something similar using the placeholders for “Year”, “Month” and “Day” in the Creation Date smart rule options, eg: