Thanks @PickleRick , I had tried using "eval myId=tonumber(recordId,26)" not realising I had to use base 36 to include 0-9. I am using strftime on the date and combining the date and recordId to give me one SNow ID per day for each record. This gives me the solution I require.
... View more