Is there something in SS I can use to manipulate dates? e.g. add a month to result.getValue('trandate');

custom function or use moment.js

can you modify the search to take advantage of any date functions? or maybe SuiteQL has some date functions that can help?