It's a bit clunky but here is a screenshot of the Generate Attributes operator with the various calculations. It shows how much flexibility there is hidden within this operator.
I'm not sure what would happen over a year boundary so it might be worth doing some more checks in this case.
I can think of a couple of other ways this could be done but I might ask for beer or money to work out the details.
hahaha - beer money - can I send you the beer?
ReplyDeleteThanks for that mate - I tried for several days to figure out an elegant solution but I probably don't have the brainpower for that.
Beer is always worth it :)
ReplyDeleteIt really isn't brainpower by the way - it's experience...