I have been trying to export a dataset to CSV. The export is working but I am also trying to format the date/time. Currently it is being exported in the form “Tue Sep 13 02:16:56 PDT 2022” but I need to be in this form “2022-09-13 02:16:56.107”. I have tried using
Sounds like you aren’t assigning the return value from system.dataset.formatDates. Datasets are immutable–unchangeable. Functions like this one return a new dataset with the requested changes. Assign that to your table. (Or feed it to your CSV conversion.)
I have tried using system.date.parse(myDataset.getValueAt(row,column), 'MMMM dd, yyyy hh:mm') to create a Date object but I still get the error: java.text.ParseException: java.text.ParseException: Unparseable date: "Tue Sep 13 02:16:56 PDT 2022" How can I get past this?